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
EXIT
force a tie to be completed unconditionally. When the statementEXIT
is 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.