Oracle | WM

Oracle WM_ERROR 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 WMSYS Error Handler

AUTHID DEFINER

Dependencies

DBMS_STANDARD	LTPRIV	OWM_DYNSQL_ACCESS
LT	LTRIC	OWM_IEXP_PKG
LTADM	LTUTIL	OWM_MIG_PKG
LTAQ	LT_CTX_PKG	OWM_MP_PKG
LTDDL	LT_EXPORT_PKG	PLITBLM
LTDEFINER	OWM_BULK_LOAD_PKG	UD_TRIGS
LTI	OWM_DDL_PKG	WM_DDL_UTIL

Documented No

Exceptions

Error Code	Reason
ORA-20383	Workspace Manager must first be uninstalled from each pdb prior to uninstalling from CDB$ROOT

First Available Not known

Security Model Owned by WMSYS with no privileges granted.

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

Subprograms

GETERRORSTR

RAISEERROR

GETERRORSTR

Returns error code for WMSYS in the range of -20001 to -20400 wm_error.geterrorstr(error_no IN NUMBER) RETURN VARCHAR2;

SELECT wmsys.wm_error.geterrorstr(-20001);

      

      WMSYS.WM_ERROR.GETERRORSTR(-20001)

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

      RAISE_APPLICATION_ERROR(-20001, 'name of column '%s' has more than %s characters')

RAISEERROR

Raises the associated Workspace Manager error

Overload 1 wm_error.raiseerror(error_no IN NUMBER);

exec wmsys.wm_error.raiseerror(wmsys.lt.wm_error_383_no);

          
      *

      ORA-20383: Workspace Manager must first be uninstalled from each pdb prior to uninstalling from CDB$ROOT

Overload 2 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2);

TBD

Overload 3 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2);

TBD

Overload 4 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2);

TBD

Overload 5 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2, arg4 IN VARCHAR2);

TBD

Overload 6 wm_error.raiseerror( error_no IN NUMBER, arg1 IN VARCHAR2, arg2 IN VARCHAR2, arg3 IN VARCHAR2, arg4 IN VARCHAR2, arg5 IN VARCHAR2);

TBD