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
- 11724 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 are rollup and cube in t-sql? : Transact sql
What is the purpose of the partition table?
explain mysql aggregate functions. : Sql dba
What types of commands can be executed in sql*plus?
How do I access sql anywhere database?
Does sql*plus have a pl/sql engine?
Does truncate free space?
What is difference between hql and native sql?
Name the operator which is used in the query for pattern matching?
Is sql harder than python?
What is rank () in sql?
Explain some predefined exceptions.
What packages are available to pl/sql developers?
what are all different types of collation sensitivity? : Sql dba
Are sql connections encrypted?
