Sign Up Login


  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is an Exception ? What are types of Exception ?

Question Posted / tulsi

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


Please Help Members By Posting Answers For Below Questions

What are stuff and replace function?

774

Are pl sql variables case sensitive?

775

how to create a new table in mysql? : Sql dba

721

What is difference between function and trigger?

721

Can you upgrade sql express to full sql?

714

What is the maximum number of rows in sql table?

745

What is scalar function in sql?

706

What is the use of function in sql?

734

What is schema in sql?

686

what is the difference between char_length and length? : Sql dba

791

how to create a table index in mysql? : Sql dba

752

How many types of index are there?

724

How do you identify a primary key?

815

What is pl sql variable?

703

What is dcl in sql?

701