scope of exception handling in plsql
Answers were Sorted based on User's Feedback
Answer / suresh kumar somayajula
Raising an error in PL/SQL execution block is nothing
but "Execption". These are of 2 types.
1.Predefined Exception 2. User defined Exception
Total 19+1 predefined exceptions are there.
19+1 means 19+When Others.
"When others" is the last one.After "When Others" no
exception will be raised.
Eg. for Predefined Exceptions:
No_data_found,Dup_val_on_index,Invalid_cursor,Invalid_number
,Zero_Divide,.......,'When Others'..
Thank you,
Suresh.
Is This Answer Correct ? | 8 Yes | 2 No |
Answer / 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 |
Answer / shanmukha srinivas
scope of exception (importance of exception)
exceptions r run time errors
in real time every procedures,functions used exception section at the end of program
because its gives which line get error comes, which error is coming by using error log table.
Is This Answer Correct ? | 0 Yes | 0 No |
what are local and global variables and their differences? : Sql dba
how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00
What is on delete restrict?
What are the operators in sql?
How can i insert data inro a table with 3 columns using FORALL?
What is difference between a Cursor declared in a procedure and Cursor declared in a package specification ?
What is use of trigger?
what is oltp (online transaction processing)? : Sql dba
what is difference between stored procedures and application procedures,stored function and application function?
What are the types of optimization?
What are local and global Indexes and where they are useful.
What is a temp table?