Raise_Application_Error() in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

Raise_Application_Error() in Oracle PL SQL Interview Questions And Answers For Experience & Freshers | Interview Preparation

It is oracle predefined exception procedure which is available in dbms_standard package. If we want to display user defined exception message in more descriptive form then we are using this procedure.

It can be used in executable section or exception section of the PLSQL block. This procedure accepts two parameters.

Syntax:

raise_application_error(error number, message)

range

error number: -20000 to -20999

message: up to 512 characters


raise_application_error procedure is used in triggers because it stops invalid data entry into table. It is exception procedure whenever condition is true it raise a message and control does not goes to next line.


Please do check our daily posts, videos for beneficial informations, in case of any additional queries please do contact us, we are happy to assist you.

Please Do SUBSCRIBE our Youtube Channel and Support us :-
https://www.youtube.com/a4uofficial

If any difficulties regarding our posts, videos or other problem you can direct contact us:- allforyoucreators@gmail.com

If you found this post was helpful then please don't forget to SUBSCRIBE our channel.
Subscribe us for more such posts, videos and updates.. It's Free!!

For Businesses Inquiries :- allforyoucreators@gmail.com
_____________________________________________________________________________

Join Us on Social Media -
Like our Facebook Page :- https://www.facebook.com/a4u0fficial/

PLEASE SUBSCRIBE US FOR MORE POSTS, VIDEOS AND STAY TUNED..
CREATIVE, INFORMATIVE & BENEFICIAL CONTENTS TO BE FOUND ON OUR CHANNEL!!
BECAUSE WE KEEP UPLOADING VIDEOS ON YOUTUBE FOR YOU..
ALL WE NEED IS YOUR SUPPORT ❤

=▶ Thanks for your Love and Support ◀=

Copyright ©All For You Official

Post a Comment

0 Comments