Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36455 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
Do we need commit after truncate?
Is primary key is clustered index?
How does cross join work in sql?
How can we debug in PL/SQL?
What is pl sql in dbms?
What is embedded sql what are its advantages?
What is difference between group by and partition by?
What is the difference between the sql*loader and import utilities? : aql loader
Why partition by is used in sql?
How can we make an if statement within a select statement?
How many types of privileges are available in sql?
What is difference between cursor and trigger?
Show code of a cursor for loop.
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the 3 modes of parameter?
