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
What does trigger mean in slang?
How do you run a query?
How many sql core licenses do I need?
What is %type in pl sql?
what are the properties and different types of sub-queries? : Sql dba
What is sql query optimization?
Do we need to rebuild index after truncate?
What is dialect in sql?
Can we use pl sql in sql server?
What is offset in sql query?
Which version of sql do I have?
What is duration in sql profiler trace?
How many sql are there?
What is the difference between the implicit and explicit cursors?
what are the difference between clustered and a non-clustered index? : Sql dba
