Explain the types of Exceptions.Predefined oracle exceptions These are the PL/SQL runtime engine raised named system exceptions. These exceptions are raised automatically by the program. You cannot control when PL/SQL will raise a system exception.
User-defined exceptions These are programmer raised named exceptions. The programmer can use an explicit call to the RAISE statement to raise a programmer-defined or system-named exception. The programmer can also raise unnamed, programmer-defined exceptions and re-raised "current" exceptions.
|
Oracle ExceptionsOracle Exceptions - Define Exceptions in PL/SQL, Explain how to define and raise exceptions in PL/SQL, What is Pragma Init Exception in oracle?, How exceptions are raised in oracle?.......