Raise application error

Can we raise_application_error in exception block?? if we use what will happen?
  • Interview Candidate
  • 3
  • 6149

Showing Answers 1 - 3 of 3 Answers

Sandhya.Kishan

  • Jun 18th, 2012
 

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