Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
Why stored procedure is faster than query?
Is sql a backend?
what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba
What is join view in sql?
What is pl sql package?
What is a function in oracle pl sql?
how to calculate expressions with sql statements? : Sql dba
how would you get the current date in mysql? : Sql dba
How can I get the number of records affected by a stored procedure?
How do you modify a trigger?
What are the usages of sql?
How to run sql statements through the web interface?
how can we know the number of days between two given dates using mysql? : Sql dba
How do you optimize a query?
What do you understand by exception handling in pl/sql?
