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
Define a temp table?
How do I create a sql script?
Mention what are different methods to trace the pl/sql code?
Why partition by is used in sql?
Define commit?
Can a primary key be a foreign key?
What is rownum?
What is an exception in PL/SQL? What are the two types of exceptions?
What is pl sql code?
what is column? : Sql dba
what are numeric data types? : Sql dba
Is full outer join same as cross join?
what are the type of locks ? : Sql dba
what is self-join? : Sql dba
Can a procedure in a package be overloaded?
