What is Pragma Init Exception in oracle?

What is Pragma Init Exception in oracle? Difference between user defined exception and init pragma exception.

Pragma Init Exception is declared using the following syntax:-
PRAGMA EXCEPTION_INIT(exception_name, oracle_error_nb);

This directs the compiler to add the user defined error message to the oracle error number. It associate the user defined error message to predefined error codes.

Pragma init exception is used to associate a user defined exception with an error number and a custom message where as User-defined exception is raised explicitly. Pragma Init exception can be associated with an Oracle inter error and be raised implicitly.
Disadvantages of trigger in oracle.
Triggers can execute every time some field in database is updated. If a field is likely to be updated often, it is a system overhead.......
What is a NOCOPY parameter in oracle?
Apart from IN, OUT, IN OUT parameters, oracle 8i offers another parameter called NOCOPY.....
What is Raise_application_error in oracle?
Raise_application_error allows users to create custom error messages...
Post your comment