types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
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
State few characteristics of pl/sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
What is the use of function in sql?
Which command is used to delete a package?
What is constant in pl sql?
Is sqlite thread safe?
How to start oracle sql developer?
Can we connect to postgresql using sql developer?
how to decrement dates by 1 in mysql? : Sql dba
what is a stored procedure? : Sql dba
What are procedures used for?
How many types of privileges are available in sql?
Is sql low level language?
What is the usage of nvl function?
How many sql core licenses do I need?