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
- 11726 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
How to revise and re-run the last sql command?
Can we write dml inside a function in sql server?
Why is the cursor important?
What is the purpose of cursors in pl/sql?
How to fix oracle error ora-00942: table or view does not exist
how to get @@error and @@rowcount at the same time? : Sql dba
Why stored procedures are faster than query?
How to order siblings in oracle hierarchy queries?
How to Execute a Package in PL/SQL.?
How can I speed up sql query?
How many postgresql users are there, worldwide?
What are the different ddl commands in sql?
Why schema is used in sql?
Is and as keyword in pl sql?
How do you write a complex sql query?
