What is an Exception ? What are types of Exception ?
- 2 Answers
- 6451 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 basic structure of pl sql?
What is procedure and function in sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How do you identify a primary key?
What is the purpose of cursors in pl/sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What are the different ways to optimize a sql query?
What is db journal file?
How to know the last executed procedure?
list out some tools through which we can draw e-r diagrams for mysql. : Sql dba
What is primary and foreign key?
How do you modify a trigger?
What is Collation Sensitivity ? What are the various type ?
What is sql table?
What is the difference between inner join and left join?
