1
I noticed the command exit works like a break, it stops running the current block and switches to the next one, but which command can stop the whole procedure in PL/SQL?
1
I noticed the command exit works like a break, it stops running the current block and switches to the next one, but which command can stop the whole procedure in PL/SQL?
1
According to the documentation, to terminate the routine execution you must use the command RETURN.
Rectifying something you mentioned, the command Exit would be to terminate execution of ties.
The EXIT statement forces a loop to complete unconditionally. When an EXIT statement is encountered, the loop completes immediately and control passes to the next statement
In free translation:
The command
EXITforce a tie to be completed unconditionally. When the statementEXITis met, the loop is completed immediately and control is passed to the command line after the loop
I hope this helps.
Browser other questions tagged sql oracle pl-sql
You are not signed in. Login or sign up in order to post.