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
- 11694 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 is a full join?
How do you determine the current isolation level? : Transact sql
What is normalization in a database?
Which command is used to call a stored procedure?
Are stored procedures compiled?
Is a foreign key always unique?
how to run 'mysql' commands from a batch file? : Sql dba
What is sql in oracle?
What do you understand by pl/sql records?
How long does it take to learn pl sql?
What is program debugging?
Do stored procedures prevent sql injection?
Is sql a scripting language?
What is rownum in sql?
Define implicit and explicit cursors.
