Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36668 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 table? : Sql dba
explain the difference between delete , truncate and drop commands? : Sql dba
Differentiate between syntax and runtime errors.
What does := mean in pl sql?
How to run sql commands in sql*plus?
What are the types of records?
where are cookies actually stored on the hard disk? : Sql dba
Explain what is a database?
What is sql select statement?
Can we use joins in subquery?
Is sql a programming?
What are the parameter modes supported by pl/sql?
Can primary key be changed?
What are types of joins?
Cite the differences between execution of triggers and stored procedures?
