What is an Exception? What are types of Exception?
Submitted by: AdministratorException is the error handling part of PL/SQL block. The types are Predefined and user defined. Some of 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.
exception is an identifier and error handling part of pl/sql types := 1)predifined
2) user defined.
Submitted by: Administrator
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.
exception is an identifier and error handling part of pl/sql types := 1)predifined
2) user defined.
Submitted by: Administrator
Read Online Oracle PL-SQL Job Interview Questions And Answers
Top Oracle PL-SQL Questions
☺ | Explian rowid, rownum?what are the psoducolumns we have? |
☺ | what is the starting oracle error number? |
☺ | What is difference b/w stored procedures and application procedures, stored function and application function? |
☺ | In a Distributed Database System Can we execute two queries simultaneously? Justify? |
☺ | Name the tables where characteristics of Package, procedure and functions are stored? |
Top DB Oracle Categories
☺ | Oracle PL-SQL Interview Questions. |
☺ | Oracle DBA Interview Questions. |
☺ | Oracle D2K Interview Questions. |
☺ | OCI Interview Questions. |
☺ | Forms Reports Interview Questions. |