1. Get unlimited access to documents by upgrading to Premium Membership.
  2. We are not accepting new members currently. If you would like to join, please contact us.
    Dismiss Notice

Some more predefined exceptions in oracle 2009-08-30

Some more predefined exceptions in oracle

  1. salmankhalid
    Summary of Predefined PL/SQL Exceptions

    An internal exception is raised automatically if your PL/SQL program violates an Oracle rule or exceeds a system-dependent limit. PL/SQL predefines some common Oracle errors as exceptions. For example, PL/SQL raises the predefined exception NO_DATA_FOUND if a SELECT INTO statement returns no rows.

    You can use the pragma EXCEPTION_INIT to associate exception names with other Oracle error codes that you can anticipate. To handle unexpected Oracle errors, you can use the OTHERS handler. Within this handler, you can call the functions SQLCODE and SQLERRM to return the Oracle error code and message text. Once you know the error code, you can use it with pragma EXCEPTION_INIT and write a handler specifically for that error.

    PL/SQL declares predefined exceptions globally in package STANDARD. You need not declare them yourself. You can write handlers for predefined exceptions using the names in the following list:

    kindly view the attachment for some Predefined Oracle Exceptions............

Recent Reviews

  1. ShaheerBadar
    Version: 2015-07-14
    thanks very
  2. Sadik
    Version: 2015-07-14
    Hi... just edited the article for better readability, hope you don't mind... :)