Oracle | DBMS_SERVICE

Oracle DBMS_SERVICE_ERR Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_SERVICE	DBMS_SERVICE_LIB	DBMS_SYS_ERROR
DBMS_SERVICE_CONST	DBMS_SERVICE_PRVT

Documented No

First Available 12.1.0

Security Model Owned by SYS with EXECUTE granted to the DBA role

Source {ORACLE_HOME}/rdbms/admin/prvtsrv.plb

Subprograms

FOLD_KSWS_ERROR

HANDLE_ERROR

FOLD_KSWS_ERROR

Undocumented dbms_service_err.fold_ksws_error(ksws_err IN NUMBER) RETURN NUMBER;

SELECT dbms_service_err.fold_ksws_error(00600)

      FROM dual;

      

      DBMS_SERVICE_ERR.FOLD_KSWS_ERROR(00600)

      ---------------------------------------

      -44309

HANDLE_ERROR

Undocumented

An ORA-00600, by any other name, smells as bitter dbms_service_err.handle_error( errnum IN NUMBER, arg1 IN VARCHAR2);

exec dbms_service_err.handle_error(44316, 'err_invalid_argument

');

      BEGIN dbms_service_err.handle_error(44316, 'err_invalid_argument'); 
      END;

      *

      ERROR at line 1:

      ORA-44309: unknown failure

      ORA-06512: at "SYS.DBMS_SERVICE_ERR", line 36

      ORA-06512: at line 1