Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36662 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 I view a sql trace file?
What is sql server and ase?
Explain normalization and what are the advantages of it?
What is an alias command?
How do I save the results of sql query in a file?
What is date functions?
explain the delete statements in sql
what are the advantages and disadvantages of views in a database? : Sql dba
What is difference between stored procedure and trigger?
How do you rank data in sql?
Which table is left in join?
Which is better trigger or stored procedure?
What are the sql versions?
What are different types of queries in sql?
what is the difference between myisam static and myisam dynamic? : Sql dba
