Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between pragma exception_init and
raise_application_error
- 1 Answers
- 36436 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 insert into statements in sql?
What are the advantages of pl sql over sql?
Does sql backup shrink transaction log?
What are the differences between in and exists clause?
What is data control language (dcl)?
What is basic structure of pl sql?
Table Order_Name has a column Order_Date which gives the date & Time at which the order is passed.Find the table to write a query to find out the latest order.
How much does sqlite cost?
What is mutating error?
Can we use threading in pl/sql?
What are sql objects?
What is mdf ldf and ndf?
-
Oracle (3259) - 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)
