What is Pragma EXECPTION_INIT ? Explain the usage ?
Answers were Sorted based on User's Feedback
Answer / tulsi
The PRAGMA EXECPTION_INIT tells the complier to associate
an exception with an oracle error. To get an error message
of a specific oracle error.
e.g. PRAGMA EXCEPTION_INIT (exception name, oracle error
number)
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / harish
Oracle have some builtin errors but they have only error
code not the error name user can define this builtin errors
by using Pragma EXECPTION_INIT
| Is This Answer Correct ? | 1 Yes | 1 No |
What is difference between % ROWTYPE and TYPE RECORD ?
How does a covering index work?
How many primary keys can a table have?
how is myisam table stored? : Sql dba
What are the cursor attributes used in PL/SQL ?
what is the difference between cluster and non cluster index? : Sql dba
Can i possible to see Table Details ? Ex : Table Name Date Time User Emp May/18/2010 12:59pm Scott
Explain what is a database?
Why do you partition data?
What are sql queries used for?
Which is better stored procedure or query?
What is the difference between explicit and implicit cursors in oracle?
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)