Raise application error

Can we raise_application_error in exception block?? if we use what will happen?

Showing Answers 1 - 1 of 1 Answers

Whenever a message is displayed using RAISE_APPLICATION_ERROR, all previous transactions which are not committed within the PL/SQL Block are rolled back automatically .

RAISE_APPLICATION_ERROR is used for the following reasons,

a) to create a unique id for an user-defined exception.
b) to make the user-defined exception look like an Oracle error.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions