types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / muthu nagaraj
pragma autonomous_transaction are used to implement DCL
queries in a trigger
Is This Answer Correct ? | 1 Yes | 0 No |
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 |
What are the features of pl sql?
What type of database is sql?
Can we use having without group by in sql?
Mention what plvcmt and plvrb does in pl/sql?
how to calculate the difference between two dates? : Sql dba
why we go for package? what are the advantages of using instead of seperate procuderes or functions
what is 'mysqldump'? : Sql dba
Which table is left in join?
What are the benefits of triggers?
List different type of expressions with the example.
Mention what does the hierarchical profiler does?
how to dump a table to a file with 'mysqldump'? : Sql dba