Oracle | OWM_VSCRIPT

Oracle OWM_VSCRIPT_PKG Version 21c

General Information

Library Note

Morgan's Library Page Header

ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.

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_TRIGGERS	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	LTI	WM_DDL_UTIL
DBA_SYNONYMS

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

Direct access to some objects in this package is prevented by means of 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;

      BEGIN wmsys.owm_vscript_pkg.startQueue; END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object STARTQUEUE

STOPQUEUE

Undocumented owm_vscript_pkg.stopQueue(dropqueueandtable IN BOOLEAN);

exec wmsys.owm_vscript_pkg.stopQueue(FALSE);

      BEGIN wmsys.owm_vscript_pkg.stopQueue(FALSE); END;

            *

      ERROR at line 1:

      ORA-06550: line 1, column 7:

      PLS-00904: insufficient privilege to access object STOPQUEUE

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

Appears to be protected by an Accessible By clause owm_vscript_pkg.wm$convertVersionStr(version_str IN VARCHAR2) RETURN VARCHAR2;

SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')

      FROM dual;

      SELECT wmsys.owm_vscript_pkg.wm$convertVersionStr('21.3')

             *

      ERROR at line 1:

      ORA-06553: PLS-904: insufficient privilege to access object WM$CONVERTVERSIONSTR

WM$EXECRECORDS

Undocumented owm_vscript_pkg.wm$execRecords RETURN CLOB;

SELECT wmsys.owm_vscript_pkg.wm$execRecords

      FROM dual;

      

      WM$EXECRECORDS

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

      declare

              procedure revokePriv(sqlstr varchar2) is

              begin

                execute immediate sqlstr;

              end;

      

              procedure grantPriv(sqlstr varchar2) is

              begin

                execute immediate sqlstr;

              end;

              begin

                null;

      end;

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;

      /

      T

      

      PL/SQL procedure successfully completed.

WM$INSTALLPATCH

Apply Workspace Manager patch owm_vscript_pkg.wm$installPatch;

exec wmsys.owm_vscript_pkg.wm$installPatch;

      

      PL/SQL procedure successfully completed.

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;

      /

      T

      

      PL/SQL procedure successfully completed.

WM$UTLRP

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

exec wmsys.owm_vscript_pkg.wm$utlrp;

      

      PL/SQL procedure successfully completed.