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
- 11501 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 display the current date in sql?
Is id a reserved word in sql?
What is foreign key and example?
What is data type in sql?
How do I create a sql database?
how to rename an existing table in mysql? : Sql dba
What is partition in sql query?
What is the purpose of the partition table?
Explain the select statement in sql?
Is pl sql different from sql?
Can we use having without group by in sql?
Explain what is sql?
How to use sql statements in pl/sql?
What does the acronym acid stand for in database management?
What is a sql schema used for?
