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
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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DML_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_VT_PKG
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx