Exit command in PL/SQL

Asked

Viewed 387 times

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 answer

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 statement EXIT 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

You are not signed in. Login or sign up in order to post.