DEVFYI - Developer Resource - FYI

What occurs if a procedure or function terminates with failure without being handled?

PL/SQL Interview Questions and Answers


(Continued from previous question...)

What occurs if a procedure or function terminates with failure without being handled?

1. Any DML statements issued by the construct are still pending and can be committed or rolled back.
2. Any DML statements issued by the construct are committed
3. Unless a GOTO statement is used to continue processing within the BEGIN section, the construct terminates.
4. The construct rolls back any DML statements issued and returns the unhandled exception to the calling environment.

(Continued on next question...)

Other Interview Questions