Oracle | DBMS_SERVICE

Oracle DBMS_SERVICE_ERR Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

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);

      

      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');

           *

      ORA-44309: unknown failure