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
- 11495 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
How do you change a value in sql?
The in operator may be used if you know the exact value you want to return for at least one of the columns.
Is join an inner join?
What is update query?
What is the sql*loader? : aql loader
Does a primary key have to be a number?
What is multiple columns?
What are the three forms of normalization?
Which query operators in sql is used for pattern matching?
Can we use ddl statements in stored procedure sql server?
What does closing a cursor do?
Why function is used in sql?
what is heap table? : Sql dba
What is the current version of postgresql?
How to fix oracle error ora-00942: table or view does not exist
