What is an Exception ? What are types of Exception ?
Answer Posted / tulsi
Exception is the error handling part of PL/SQL block. The
types are Predefined and user_defined. Some of Predefined
execptions are.
CURSOR_ALREADY_OPEN
DUP_VAL_ON_INDEX
NO_DATA_FOUND
TOO_MANY_ROWS
INVALID_CURSOR
INVALID_NUMBER
LOGON_DENIED
NOT_LOGGED_ON
PROGRAM-ERROR
STORAGE_ERROR
TIMEOUT_ON_RESOURCE
VALUE_ERROR
ZERO_DIVIDE
OTHERS.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How is indexing done in search engines?
What is sql and db2?
What is the difference between distinct and unique in sql?
What are the types of join and explain each?
what is 'mysqlshow'? : Sql dba
Why is sql better than hql?
Is sql scripting language?
how to concatenate two character strings? : Sql dba
What is out parameter used for eventhough return statement can also be used in pl/sql?
What are the benefits of pl/sql packages?
How do you define a foreign key?
Why is normalization important?
What will you get by the cursor attribute sql%rowcount?
What are string functions in sql?
what are different types of collation sensitivity? : Sql dba