Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36566 Views
- Aetins, State Street, I also Faced
- E-Mail Answers
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
Define select, insert, create, delete, update, drop keywords
What is the difference between subquery and correlated query?
What is information schema in sql?
How do we accept inputs from user during runtime?
Show how functions and procedures are called in a pl/sql block.
What are the advantages of stored procedure?
What are few of the schema objects that are created using PL/SQL?
What are the steps for performance tuning.
how many sql dml commands are supported by 'mysql'? : Sql dba
what are all the different types of indexes? : Sql dba
How many commands are in sql?
Can we use having without group by in sql?
what is the difference difference between procedure and packages
How to pipe multiline string to isql?
What does trigger mean in psychology?
