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 usage of when clause in trigger?
what is difference between delete and truncate commands? : Sql dba
how to convert character strings to numeric values? : Sql dba
What are the different dcl commands in sql?
What is cursor in pl sql with examples?
What is procedure and function in sql?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is the difference between nvl function, ifnull function, and isnull function?
What are sql procedures?
What are the types of subqueries?
What is a data definition language?
Define union, minus, union all, intersect ?
What does rownum mean in sql?
Is sql port 1433 encrypted?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...