Interested to Buy Any Domain ? << Click Here >> for more details...
What is an Exception ? What are types of Exception ?
- 2 Answers
- 7331 Views
- I also Faced
- E-Mail Answers
Answer Posted / chintu
Any ubnormal event in a program is called Exception.
In pl/ sql there are two types of exceptions they are
Userdefind Exception and predefined Exceptions.
Predefined exceptions 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.
user defined exceptions are defined by raise_application_
error("error msg","error number") and
pragma_exception_init()
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is procedure explain with example?
Is join an inner join?
Can we write dml inside a function in sql server?
How does an execution block start and end in pl sql?
What is sqlexception in java?
What is pivot table in sql?
What are the features of pl sql?
What are the advantages of indexing?
What are the types of subqueries?
what are the advantages of mysql in comparison to oracle? : Sql dba
How do we use distinct statement? What is its use?
What is an inconsistent dependency?
What is group by in sql?
What is a full join?
What is the use of index in sql?
