Pragma EXCEPTION_INIT is used to associate a user-defined exception name with a specific internal Oracle error number (ORA-nnnnn). This allows the programmer to write an explicit 'WHEN' handler for an error that doesn't have a pre-defined name in PL/SQL.