types of exceptions and what is meant by pragma
autonomous_transaction ?what is the use.
- 4 Answers
- 10686 Views
- 3i Infotech, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What problem one might face while writing log information to a data-base table in pl/sql?
What is the purpose of using pl/sql?
How do you optimize a query?
How do I run sql profiler?
Explain correlated query work?
Compare sql & pl/sql
what is subquery? : Sql dba
What is the maximum database size for sql express?
Can we use loop in sql?
What does the acronym acid stand for in database management?
What is the difference between numeric and autonumber?
What are the different schemas objects that can be created using pl/sql?
What are triggers in sql?
How many sql statements are used?
what are date and time intervals? : Sql dba
