Interested to Buy Any Domain ? << Click Here >> for more details...
types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
- 4 Answers
- 11862 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / rajesh venati
Exceptions are classified into two types,
They are
1. Predefined Exceptions
2. User Defined Exceptions
==> Oracle created some of the Predefined Exceptions like
ex: no_data_found etc.,
==> User Defined Exceptions are created by us.
types of user defined exceptions are
a. Raise
b. Raise_Application_Error
One more exception also there
pragma exception_init(exception,error_code)
Then come for Pragma Autonomous Transaction.
Pragma Autonomous Transaction is used to commit or rollback
the active block only.
As well as in a triggers dcl commands are not possible to
used, if u want use dcl command inside a triggers then we
will go for pragma autonomous transaction.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
Can cursors be part of a trigger body?
What is an example of translating a date into julian format?
How is a PL/SQL code compiled?
what is auto increment? : Sql dba
How many types of tables are there?
when MSQL8.0 is in market
What is the difference between left and left outer join?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is the use of procedures?
What are the uses of sysdate and user keywords?
how to get @@error and @@rowcount at the same time? : Sql dba
What is left inner join in sql?
What are basic techniques of indexing?
What are the advantages of pl sql over sql?
