I have a pl/sql procedure for oracle 8.1.6 and I have multiple if..then statements.
I want to be able to leave the procedure (i.e. exit) after a certain condition is met... I do not want to have to write in all the conditions into each if..then statement. Especially since I am working with cursors.. it could get ugly.
If anyone knows how to get out .. please let me know.
It's not possible to use IF THEN ELSIF?
You can use RETURN to leave the procedure:
THEN statement1; return;
THEN statement2; return;
Click Here to Expand Forum to Full Width