Oracle | DBMS_SERVICE

Oracle DBMS_SERVICE_ERR Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

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