Oracle
1Z0-144 · Question #63
Which two statements are true about PL/SQL exception propagation? (Choose two.)
The correct answer is A. The exception reproduces Itself In successive enclosing blocks until a handler is found. C. If you declare a local exception in a subblock and a global exception in the outer block, the local. Exceptions cannot propagate across remote subprogram invocations. Therefore, a PL/SQL block cannot handle an exception raised by a remote subprogram.
Handling Exceptions
Question
Which two statements are true about PL/SQL exception propagation? (Choose two.)
Options
- AThe exception reproduces Itself In successive enclosing blocks until a handler is found.
- BException- can propagate across the remote subprograms that are called through database links.
- CIf you declare a local exception in a subblock and a global exception in the outer block, the local
- DIf you declare a local exception in a subblock and a global exception in the outer block, the global
How the community answered
(28 responses)- A71% (20)
- B7% (2)
- D21% (6)
Explanation
Exceptions cannot propagate across remote subprogram invocations. Therefore, a PL/SQL block cannot handle an exception raised by a remote subprogram.
Topics
#exception propagation#nested blocks#local exceptions#global exceptions
Community Discussion
No community discussion yet for this question.