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 a primary key called that is made up of more than one field?
Why do we need view in sql?
Can we create clustered index without primary key?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
How to select all records from the table?
What has stored procedures in sql?
How much ram can sql express use?
Can you sum a count in sql?
give the syntax of grant and revoke commands? : Sql dba
What is graph sql?
What is sqlexception in java?
how to delete an existing column in a table? : Sql dba
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How do I remove all records from a table?
when MSQL8.0 is in market