Answer Posted / madhuri
Execution is exception is done in many ways.
An exception occurs when there is something wrong in the
code of pl/sql block.
Exception can be raised either in declarative,executable or
in exception section itself.
In case of nested blocks when an exception occurs in inner
block,it will try to find its handle in the same block,if
not then control comes out of inner block and executes the
handler in the outer block.
When exception occurs in declarative and exception
section,then control is propagated to the next outer block.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you have more than one key in a database?
what is a control file ? : Sql dba
What are different types of indexes?
Why use triggers in sql?
what is oltp (online transaction processing)? : Sql dba
What are the different operators available in sql?
What is a table partition?
Why is a trigger used?
What is dbo in sql?
What does closing a cursor do?
What is substitution variable in pl sql?
explain the advantages and disadvantages of stored procedure? : Sql dba
What is sql partition?
What is an oracle stored procedure?
How do you break a loop in pl sql?