Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36667 Views
- Aetins, State Street, I also Faced
- E-Mail Answers
Answer / 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 |
How do I write a cron which will run a sql query and mail the results to agroup?
How do you update a sql procedure?
Can we relate two different tables from two different users in ORACLE,PL/SQL?
How to get help at the sql prompt?
Is sql a backend?
what are the advantages of using stored procedures? : Sql dba
How much does sql certification cost?
what is foreign key? : Sql dba
How many types of privileges are available in sql?
How do you get all records from 2 tables. Which join do you use?
how to fetch common records from two tables? : Sql dba
Why is there a need for sqlcode and sqlerrm variables?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
