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 is t-sql? : Transact sql
What is sql and explain its components?
How many types of cursors supported in pl/sql?
What is use of term?
What is the use of non clustered index?
There are 5 records in a table and we have implemented two triggers that are :pre_query and post_query how many times these triggers will fire.
What is a delimiter in sas?
Does asenumerable execute the query?
What is a database trigger ? Name some usages of database trigger ?
What is difference between stored function and application function?
What is the clause we need to add in function body to return variable?
What is sql architecture?