types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
- 4 Answers
- 10683 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
what are the types of join and explain each? : Sql dba
How to pipe multiline string to isql?
Why do we use procedures in sql?
What are three advantages to using sql?
Does asenumerable execute the query?
What is a composite primary key?
how can you create an empty table from an existing table? : Sql dba
What is clustered index sql?
What is dense_rank?
Is sql a microsoft product?
What is a ddl command?
How do I create an index in word?
Explain the commit statement.
Are there any features that are decommissioned in 11g that are not present in 11g?
How do I view a view in sql?
