-
Add another Insert.....
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|