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
- 11687 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 does count (*) mean?
What is the primary key?
What is difference between stored procedure and trigger?
What is column?
What is function and procedure?
How consistent is the view of the data between and within multiple sessions, transactions or statements ?
What is the current version of sql?
What do you know by pl/sql cursors?
What is orm in sql?
What are character functions in sql?
How do I run sql profiler?
What do you mean by rowid?
what is a cursor? : Sql dba
what are the differences between require and include, include_once and require_once? : Sql dba
Is mariadb nosql?
