Oracle | OWM_MP

Oracle OWM_MP_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 Undocumented

AUTHID CURRENT_USER

Dependencies

DBMS_LOB	OWM_DDL_PKG	WM$MP_GRAPH_WORKSPACES_TABLE
DUAL	OWM_DYNSQL_ACCESS	WM$MP_PARENT_WORKSPACES_TABLE
LT	PLITBLM	WM$NESTED_COLUMNS_TABLE
LTADM	WM$CONSTRAINTS_TABLE	WM$RIC_TABLE
LTI	WM$MODIFIED_TABLES	WM$VERSIONED_TABLES
LTPRIV	WM$MP_GRAPH_NEW_VERSIONS	WM$VERSION_TABLE
LTRIC	WM$MP_GRAPH_OTHER_VERSIONS	WM$VERSION_VIEW
LTUTIL	WM$MP_GRAPH_REMAINING_VERSIONS	WM$WORKSPACES_TABLE
LT_CTX_PKG	WM$MP_GRAPH_REMOVED_VERSIONS	WM_ERROR
OWM_ASSERT_PKG

Documented No

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/owmmps.plb

Subprograms

ADDASPARENTWORKSPACE	GETGRAPHNODES	REMOVEASPARENTWORKSPACE
CREATEIMPLICITSPINGRAPH	GETNCA	SETMPPARAMETER
EXISTSMPWORKSPACE	ISMPWORKSPACE

ADDASPARENTWORKSPACE

Undocumented owm_mp_pkg.addAsParentWorkspace( workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

CREATEIMPLICITSPINGRAPH

Undocumented owm_mp_pkg.createImplicitSpinGraph( leaf_workspace IN VARCHAR2, description IN VARCHAR2)

TBD

EXISTSMPWORKSPACE

Retrns TRUE if the MP Workspace exists, else FALSE

Protected by an Accessible By clause owm_mp_pkg.existsMPWorkspace RETURN BOOLEAN;

BEGIN

        IF wmsys.owm_mp_pkg.existsMPWorkspace THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      *

      PLS-00904: insufficient privilege to access object OWM_MP_PKG

GETGRAPHNODES

Undocumented

Overload 1 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, parent_workspace_var IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

Undocumented

Overload 2 owm_mp_pkg.getGraphNodes( leaf_workspace IN VARCHAR2, node_types IN VARCHAR2) RETURN wmsys.ltutil.wm$ident_tab_bin;

TBD

GETNCA

Undocumented owm_mp_pkg.getNCA( workspace1 IN VARCHAR2, workspace2 IN VARCHAR2) RETURN VARCHAR2;

TBD

ISMPWORKSPACE

Undocumented owm_mp_pkg.isMPWorkspace( mp_leaf_workspace_VAR IN VARCHAR2, parent_workspace_VAR IN VARCHAR2) RETURN BOOLEAN;

TBD

REMOVEASPARENTWORKSPACE

Remove the parent workspace for the indicated MP Leaf workspace owm_mp_pkg.removeAsParentWorkspace( mp_leaf_workspace IN VARCHAR2, parent_workspace IN VARCHAR2);

TBD

SETMPPARAMETER

Undocumented owm_mp_pkg.setMPParameter(new_value IN VARCHAR2);

TBD