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
What is difference between stored procedures and application procedures?
What are different joins used in sql?
What is your daily office routine?
Why truncate is used in sql?
what is the difference between a local and a global temporary table? : Sql dba
What is bulk compiling in pl/sql.?
Define commit?
What is sql rowcount?
What is the basic structure of an sql?
Can we debug stored procedure?
Can sql developer connect to db2?
How do I view an execution plan in sql?
Can we connect to postgresql using sql developer?
which tcp/ip port does sql server run on? : Sql dba
What is the difference between database trigger and stored procedure?