Question

What is the PRAGMA_INIT exception?

pragma EXCEPTION_INIT, Oracle error messages, Oracle

What is the PRAGMA_INIT exception? Thank you.

Hi,

Do you mean PRAGMA EXCEPTION_INIT?

It's a way of associating names with user-defined exceptions, so you that exception handlers can refer to them by name. Here's an example from the Database Administrator's Guide:

 DECLARE
   null_salary EXCEPTION;
   PRAGMA EXCEPTION_INIT(null_salary, -20101);
 BEGIN
   ...
   RAISE_APPLICATION_ERROR(-20101, 'salary is missing');
 ...
 EXCEPTION
   WHEN null_salary THEN
   ...
 END;