what is the difference between pragma exception_init and
raise_application_error
Answer Posted / welcomeashwin
PRAGMA EXCEPTION_INIT allows to associate an Oracle error
number with the name of a user-defined error. Here you need
to defined user-defined exception before it is used in
PRAGMA EXCEPTION_INIT. There are two parameters: exception
name and error code.
RAISE_APPLICATION_ERROR allows to create meaningful error
msg.it works with un-named user defined exceptions. It
associates the number of the error with the text of the
error. Therefore, the user-defined exception does nat have a
name associated with it. There are three parameter:
err_number, err_msg, keep-err
Is This Answer Correct ? | 40 Yes | 4 No |
Post New Answer View All Answers
Explain how can you save or place your msg in a table?
What is the purpose of cursors in pl/sql?
What is mdf ldf and ndf?
What are the events on which a database trigger can be based?
What is the primary use of normalization?
What is sql used for?
What is normalization in sql?
What is duration in sql profiler trace?
What steps server process has to take to execute an update statement?
Is sql dba a good career? : SQL DBA
What is a sql schema used for?
Is mariadb nosql?
What are the different types of tables in sql?
Is oracle sql free?
How do I restart sql?