Hi All,

Could you please let me know where to put Insert statement in following scenario. I have a procedure

CREATE PROCEDURE...
variable declaration
Cursor declaration
BEGIN
OPEN cursor
FETCH...
IF (condition meet)

BEGIN

Insert into X values (xx, xy, xz)

EXCEPTION
exception handling;
END
END IF

Close cursor
end
Now my doubt is once loading in X table completed successfully(without an error), i need to write a Insert statement { insert into Z values (xx, xz) }. I do not understand where to write this statement, as it should also handle the exception part. Could you please help me on this?