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
Which command is used to delete a package?
What is auto increment?
How do you declare a variable in pl sql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
How to process query result in pl/sql?
How do I pipe the output of one isql to another?
How do you identify a primary key?
GLOBAL TEMPORARY TABLE over Views in advantages insolving mutating error?
Why do we use procedures?
What is the meaning of disabling a trigger?
What mean sql?
is it possible to pass an object or table to a procedure as an argument?
How can you create an empty table from an existing table?
What is the best partition size for windows 10?
What are the types of keys?