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
How would you pass hints to the sql processor?
what is 'mysqlcheck'? : Sql dba
What is secondary key?
Are there any features that are decommissioned in 11g that are not present in 11g?
how to write date and time literals? : Sql dba
Does db2 use sql?
How can you get sql*loader to commit only at the end of the load file? : aql loader
What is a sql profiler?
What port does sql server use?
What is a table in a database?
Which is faster truncate or drop?
What will you get by the cursor attribute sql%rowcount?
how to get a list of columns in an existing table? : Sql dba
How many indexes can be created on a table in sql?
What is varchar used for?
