Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36433 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
What is the execution plan in sql?
What is the difference between inner join and natural join?
What is sql clause?
how can we submit a form without a submit button? : Sql dba
Is full outer join same as cross join?
Which is faster subquery or join?
How do you take the union of two tables in sql?
what are date and time intervals? : Sql dba
How does postgresql compare to "nosql"?
Can I call a procedure inside a function?
What does trigger mean in psychology?
How does a self join work?
How do I sort a table in sql?
What is sqlcontext?
What are operators available in sql?
