what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 35904 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
How do you update a value in sql?
What is the difference between syntax error and runtime error?
what are date and time data types in mysql? : Sql dba
What is rank () in sql?
What are string functions in sql?
What is 19 null in sql?
Can you join views in sql?
What is serial sql?
How does pl sql work?
Can we use ddl statements in stored procedure sql server?
Explain two easy sql optimizations.
What are different types of indexes?
How can I see all tables in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
Explain ddl statements in pl/sql?
