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 |
Does it possible to pass object (or) table as an argument to a remote procedure?
2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B
Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.
What is the difference between count 1 and count (*) in a sql query?
What is difference between sql and excel?
What is a Procedure ?
Can you have more than one trigger on a table?
i have a column which may contain this kind of value: 123*67_80,12*8889_5,34*8_874 ,12*7_7 (can contain space before a comma, and this string length can be anything) now i want to split this value into two column like: column1: 123*67,12*8889,34*8,12*7 column2: 80,5,874,7 use function for this
Types of joins?
how would you get the current date in mysql? : Sql dba
Can 2 queries be executed simultaneously in a distributed database system?
What are different joins used in sql?