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
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is cross join sql?
If a cursor is open, how can we find in a pl/sql block?
How to select 10 records from a table?
How can you view the errors encountered in a trigger?
What is the difference between sql, mysql and sql server?
Can a trigger call a stored procedure?
What is the location of pre_defined_functions.
How many functions are there in sql?
how does a local variable is defined using t-sql? : Transact sql
What are the syntax and use of the coalesce function?
What does pragma mean?
How does left join work in sql?
What will you get by the cursor attribute sql%notfound?
Can unique keys be null?
