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
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
What do we need to check in database testing?
How do you create an update query?
Can we use threading in pl/sql?
What is sql query optimization?
what is the difference between blob and text? : Sql dba
How to run sql*plus commands in sql developer?
What is secondary key?
Is a table valued function object?
What is the difference between a query and a report?
What is the difference between function, procedure and package in pl/sql?
What is sql select statement?
what are the type of locks ? : Sql dba
What is an escape character in sql?
What are the three forms of normalization?