Oracle | OWM_VSCRIPT

Oracle OWM_VSCRIPT_PKG Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Oracle Workspace Manager utilities

AUTHID CURRENT_USER

Dependencies

ALL_USERS	DBA_SYS_PRIVS	LTRIC
CDB_OBJECTS	DBA_TABLES	LTUTIL
CDEF$	DBA_TAB_COLS	LT_CTX_PKG
CON$	DBA_TAB_PRIVS	LT_EXPORT_PKG
DBA_CONSTRAINTS	DBA_TRIGGERS	OBJ$
DBA_OBJECTS	DBMS_DATAPUMP	OWM_ASSERT_PKG
DBA_OPERATORS	DBMS_REGISTRY	OWM_DDL_PKG
DBA_QUEUES	DBMS_STANDARD	PLITBLM
DBA_ROLES	DBMS_UTILITY	V$OPTION
DBA_ROLE_PRIVS	LT	V$PARAMETER
DBA_SEQUENCES	LTDEFINER	WM_DDL_UTIL
DBA_SYNONYMS	LTI

Documented No

Exceptions

Error Code	Reason
ORA-06598	isufficient INHERIT PRIVILEGES privilege
PLS-00904	insufficient privilege to access object <object_name>

First Available Not known

Security Model Owned by WMSYS with no privileges granted

Direct access to this package is prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmvpkgs.plb
{ORACLE_HOME}/rdbms/admin/owmvpkgb.plb

Subprograms

STARTQUEUE	WM$CHECKEXISTINGRECORD	WM$HASCOLUMN
STOPQUEUE	WM$CONVERTVERSIONSTR	WM$INSTALLPATCH
UPGRADEOWM	WM$EXECRECORDS	WM$OBJECTEXISTS
WM$ADDRECORD	WM$GETDBPARAMETER	WM$UTLRP

STARTQUEUE

Undocumented owm_vscript_pkg.startQueue;

exec wmsys.owm_vscript_pkg.startQueue;

           *

      PLS-00904: insufficient privilege to access object STARTQUEUE

STOPQUEUE

Undocumented owm_vscript_pkg.stopQueue(dropqueueandtable IN BOOLEAN);

No demo possible due to ACCESSIBLE BY clause

UPGRADEOWM

Upgrade Workspace Manager owm_vscript_pkg.upgradeOWM( owm_version IN VARCHAR2, tab_prefix IN VARCHAR2);

TBD

WM$ADDRECORD

Undocumented owm_vscript_pkg.wm$addRecord( col1 IN VARCHAR2, col2 IN VARCHAR2, col3 IN VARCHAR2, col4 IN VARCHAR2, col5 IN VARCHAR2, ctype IN VARCHAR2, firste IN BOOLEAN);

TBD

WM$CHECKEXISTINGRECORD

Undocumented owm_vscript_pkg.wm$checkExistingRecord( col1_v IN VARCHAR2, col2_v IN VARCHAR2, col3_v IN VARCHAR2, col4_v IN VARCHAR2, col5 IN VARCHAR2, common IN VARCHAR2, ctype IN VARCHAR2);

TBD

WM$CONVERTVERSIONSTR

Undocumented owm_vscript_pkg.wm$convertVersionStr(version_str IN VARCHAR2) RETURN VARCHAR2;

No demo possible due to ACCESSIBLE BY clause

WM$EXECRECORDS

Undocumented owm_vscript_pkg.wm$execRecords RETURN CLOB;

conn / as sysdba

      

      SELECT wmsys.owm_vscript_pkg.wm$execRecords;

      ERROR:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

WM$GETDBPARAMETER

Undocumented owm_vscript_pkg.wm$getDBParameter(param_name IN VARCHAR2) RETURN VARCHAR2;

TBD

WM$HASCOLUMN

Returns TRUE if the identified table column exists, else FALSE owm_vscript_pkg.wm$hasColumn( tab_name IN VARCHAR2, colname IN VARCHAR2, schema IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_vscript_pkg.wm$hasColumn('T', 'TESTCOL', 'C##UWCLASS') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      ERROR:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

WM$INSTALLPATCH

Apply Workspace Manager patch owm_vscript_pkg.wm$installPatch;

exec wmsys.owm_vscript_pkg.wm$installPatch;

      ERROR:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

WM$OBJECTEXISTS

Returns TRUE if the identified object exists, else FALSE owm_vscript_pkg.wm$objectExists( obj_name IN VARCHAR2, obj_owner IN VARCHAR2, obj_type IN VARCHAR2) RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_vscript_pkg.wm$objectExists('T',  'C##UWCLASS', 'TABLE') THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      ERROR:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege

WM$UTLRP

Undocumented but likely recompile invalid objects (similar to UTL_RECOMP) owm_vscript_pkg.wm$utlrp;

exec wmsys.owm_vscript_pkg.wm$utlrp;

      ERROR:

      ORA-06598: insufficient INHERIT PRIVILEGES privilege