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 %type in pl sql?
When is a declare statement required?
What is partition in sql query?
What is procedure explain with program?
what is the bond code in materialized view?
How to execute a stored procedure?
What are its different types of dbms?
What are pl/sql cursor exceptions?
how to create a new table by selecting rows from another table in mysql? : Sql dba
What is difference between table and view?
what is rdbms? : Sql dba
What is the use of partition by in sql?
What is the requirement of self-join?
What is vector point function?
how to get @@error and @@rowcount at the same time? : Sql dba