Which two statements are true about PL/SQL exception propagation?

Which two statements are true about PL/SQL exception propagation? (Choose two.)

Which two statements are true about PL/SQL exception propagation? (Choose two.)

A.
The exception reproduces Itself In successive enclosing blocks until a handler is found.

B.
Exception- can propagate across the remote subprograms that are called through database links.

C.
If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

D.
If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Jyoti

Jyoti

A and C

Oracle book says:
the exception propagates in successive enclosing blocks until it finds a handler.