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
- 11705 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
Does pl sql work in mysql?
What is full join?
What is write ahead logging in sql server?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
What are the different dml commands in sql?
What is sql server and ase?
How do I start sql profiler?
Can we create clustered index without primary key?
Is mariadb a nosql database?
Can we insert in sql function?
Can we create index on primary key?
what tools available for managing mysql server? : Sql dba
how to fetch alternate records from a table? : Sql dba
Why stored procedure is better than query?
What is trigger explain it?
