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 the difference between delete and truncate commands? : Sql dba
What is a data manipulation language?
Is left join same as join?
How do I view a table in sql?
What is difference between mysql and postgresql?
What is the trigger in sql?
Why indexing is needed?
How we can create a table in pl/sql block. Insert records into it? Is it possible by some procedure or function? Please give example?
What is plpgsql language?
What is the use of sql trace?
What are stuff and replace function?
What is the difference between execution of triggers and stored procedures?
How do I upgrade sql?
how to escape special characters in sql statements? : Sql dba
Mention what does the hierarchical profiler does?
