types of exceptions and what is meant by pragma autonomous

types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.

Question Posted / gavini srikanth

4 Answers
11863 Views
3i Infotech, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use...

Answer / madhav

Exceptions are 3 types
.Predefined
.by default oracle provide error handlers and error
numbers.user can handle that.
data_not_found,too_many_rows,cursor_already_open
.Non predefined exceptions
.Error handlers are not available
.Only Error numbers are avalable
.By using pragma user can handle that
example:- child_record exception;
pragma exception_init(child_record,-2292);
.User defined exceptions
.Error handlers are not available
.Error numbers are also not available
.user can raise and handle that based on business
logic
example:-no_data exception(declaration section)
raise no_data(execution section)
when no_data then(exception sectiion)
dbms_output.put_line('data is not
available');
end;

Is This Answer Correct ?

7 Yes

0 No

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use...

Answer / suresh babu

Two types of exceptions used in oracle.
1.Predefined exceptions,which defined by oracle
already.Ex-NO_DATA_FOUND,DIVIDE_BY_ZERO,etc...
2.User defined exceptions,which defined by the user based on
their application requirement.

pragma autonomous_transaction is an independent
transaction.Once we issue commit,we cannot rollback except
the block,where we mentioned autonomous_transaction.

Is This Answer Correct ?

4 Yes

0 No

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use...

Answer / muthu nagaraj

pragma autonomous_transaction are used to implement DCL
queries in a trigger

Is This Answer Correct ?

1 Yes

0 No

types of exceptions and what is meant by pragma autonomous_transaction ?what is the use...

Answer / 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

More SQL PLSQL Interview Questions

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers Sonata,

what is the difference between truncate and drop statements? : Sql dba

0 Answers

What is procedure in pl sql?

0 Answers

what are properties of a transaction? : Sql dba

0 Answers

What is foreign key and example?

0 Answers

Does varchar need length?

0 Answers

What are the basic techniques of indexing?