Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bala
Scope of exception in plsql is handled by Exception Block..
this is depends on the code you had written.
suppose u have created one more plsql block inside a plssql
block,if the inner block is not handled any exception then
the outer block will handle the exception by defining the
situation/even like "when others then / when value_error
then... etc "
Note.. when u r using "when Others then" all the exceptions
will handle by this exception.. Even there is no error the
plsql will return 0 for this exception that is executed by
default in a plsql block. So. be carefull while writting
this kind of exception ("When others then")
| Is This Answer Correct ? | 4 Yes | 4 No |
Post New Answer View All Answers
What is coalesce sql?
What is cartesian join in sql?
Is left join inner or outer by default?
What are the dml statements?
Why triggers are used?
Why coalesce is used in sql?
What is pragma in sql?
How many sql commands are there?
What is break?
tell us something about heap tables. : Sql dba
Explain the update statement in sql
is it possible to pass an object or table to a procedure as an argument?
What is optimistic concurrency control? : Transact sql
What is normalization in a database?
Can triggers stop a dml statement from executing on a table?
