-
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.
Nick
-
It's not possible to use IF THEN ELSIF?
You can use RETURN to leave the procedure:
IF condition1
THEN statement1; return;
END IF;
IF condition2
THEN statement2; return;
END IF;
-
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
|
Click Here to Expand Forum to Full Width
|