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 is now availble. If you haven't you downloaded already: Why?

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