1.

What Is An Exception ? What Are Types Of Exception ?

Answer»

Exception 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 the error handling part of PL/SQL block. The types are Predefined and user defined. Some of Predefined exceptions are.



Discussion

No Comment Found