Oracle | LT_CTX

Oracle LT_CTX_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 Workspace Manager Oracle Text utilities

AUTHID DEFINER

Dependencies

ALL_VERSION_HVIEW	LTUTIL	WM$ALL_LOCKS_VIEW
ALL_WM_LOCKED_TABLES	LT_EXPORT_PKG	WM$CONF1_HIERARCHY_VIEW
DBMS_LOCK	OWM_BULK_LOAD_PKG	WM$CONF2_HIERARCHY_VIEW
DBMS_SESSION	OWM_DDL_PKG	WM$CURRENT_WORKSPACE_VIEW
LT	OWM_DYNSQL_ACCESS	WM$VERSION_HIERARCHY_TABLE
LTADM	OWM_IEXP_PKG	WM$VERSION_HIERARCHY_TABLE$
LTAQ	OWM_MIG_PKG	WM$WORKSPACES_TABLE
LTDDL	OWM_MP_PKG	WM_DDL_UTIL
LTDTRG	OWM_VSCRIPT_PKG	WM_ERROR
LTPRIV	PLITBLM	WM_PERIOD
LTRIC	USER_WM_LOCKED_TABLES

Documented No

First Available Not known

Security Model Owned by WMSYS with no privileges granted

Access to some subpograms prevented by an Accessible By clause.

Source {ORACLE_HOME}/rdbms/admin/owmctxs.plb
{ORACLE_HOME}/rdbms/admin/owmctxb.plb

{ORACLE_HOME}/rdbms/admin/owmr1120.plb

Subprograms

ALLOWDDLOPERATION	INSERTEXTTABROWSFORNVER	SETSAVEPOINT
APPENDNEXTVERS	REFRESHVERSINWSPCLIST	SETSTATEATTRIBUTES
CHECKFREEZESTATUS	SETACTIVETIMEFORDML	SETTABMRGWOREMOVEEVENT
CHECKNGETLOCK	SETCALLSTACKASINVALID	SETTABMRGWREMOVEEVENT
CHVLTL	SETCALLSTACKASVALID	SETTABREFRESHEVENT
EXISTSLTLOCKINFO	SETCOMMITVARS	SETTRIGGEREVENT
GETCURLOCKSTR	SETCOMPRESSWORKSPACE	SETTSINSTANT
GETCURNEXTVER	SETCONFLICTSTATE	SETUSER
GETCURRENTLOCKINGMODE	SETCOPYVARS	SETVALIDTIME
GETLTLOCKINFO	SETCRINFO	SETVALIDTIMEFILTEROFF
GETLTTABLENAME	SETDIFFVERS	SETVALIDTIMEFILTERON
GETMAXVTRANGE	SETEVCHECKPOINT	SETVARIABLE
GETMULTIWORKSPACES	SETFLIPVERSIONONREFRESH	SETVERAFTINSTANT
GETNEXTVER	SETFREEZESTATUS	SETVERBEFINSTANT
GETPARWSDELSTATUS	SETIMPORTVARS	SETVERSION
GETPARWSVER	SETINSTANT	SETVERSIONANDSTATE
GETPREVVER	SETLOCKMODE	SETWRITERSTATE
GETPURGEOPTION	SETLTLOCKINFO	SETWSPCMRGWOREMOVEEVENT
GETRICLOCKS	SETMPROOT	SETWSPCMRGWREMOVEEVENT
GETSESSIONATTRIBUTES	SETMPWORKSPACE	TO_TIMESTAMP_TZ_
GETSTATEFROMVER	SETMULTIWORKSPACES	UNSETCOMMITVARS
GETSTRIPPEDNEXTVER	SETNEWMPVARS	UNSETCOPYVARS
GETVARIABLE_B	SETNEWROOTANCVERSION	UNSETIMPORTVARS
GETVARIABLE_N	SETOPCONTEXT	UNSETPOSTVARS
GETVARIABLE_V	SETPOSTVARS	UPDATE_MODIFIED_TABLES
GETVTTABLENAME	SETPREVVER	WM$DISALLOWQNDML
INITIALIZERICLOCKINGVARS	SETROWLOCKSTATUS

ALLOWDDLOPERATION

Undocumented lt_ctx_pkg.allowddloperation(status IN VARCHAR2);

TBD

APPENDNEXTVERS

Undocumented lt_ctx_pkg.appendnextvers( oldnver IN VARCHAR2, newnver IN VARCHAR2) RETURN VARCHAR2;

TBD

CHECKFREEZESTATUS

Undocumented lt_ctx_pkg.checkfreezestatus( curstate IN VARCHAR2, curver OUT NUMBER, lock_status OUT NUMBER, l_crstatus OUT VARCHAR2, isref OUT NUMBER);

TBD

CHECKNGETLOCK

Undocumented

Overload 1 lt_ctx_pkg.checkngetlock( lockmode IN VARCHAR2, curlock IN VARCHAR2, curnextver IN VARCHAR2, curstate IN VARCHAR2, iscurver IN NUMBER, operation IN VARCHAR2, curver IN NUMBER, curds IN NUMBER, isrefreshed IN NUMBER, getcurlock IN NUMBER) RETURN VARCHAR2;

TBD

Overload 2 lt_ctx_pkg.checkngetlock( lockmode IN VARCHAR2, curlock IN VARCHAR2, curnextver IN VARCHAR2, curstate IN VARCHAR2, iscurver IN NUMBER, operation IN VARCHAR2, curver IN NUMBER, curds IN NUMBER, isrefreshed IN NUMBER, incoming_row_ltlock_v IN VARCHAR2, getcurlock IN NUMBER) RETURN VARCHAR2;

TBD

CHVLTL

Undocumented lt_ctx_pkg.chvltl(validtillstr IN VARCHAR2) RETURN VARCHAR2;

TBD

EXISTSLTLOCKINFO

Undocumented lt_ctx_pkg.existsltlockinfo( wm_ltlock IN VARCHAR2, info IN VARCHAR2) RETURN NUMBER;

TBD

GETCURLOCKSTR

Undocumented lt_ctx_pkg.getcurlockstr RETURN VARCHAR2;

SELECT lt_ctx_pkg.getcurlockstr

      FROM dual;

      

      GETCURLOCKSTR

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

GETCURNEXTVER

Undocumented lt_ctx_pkg.getcurnextver RETURN VARCHAR2;

SELECT lt_ctx_pkg.getcurnextver

      FROM dual;

      

      GETCURNEXTVER

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

      -1

GETCURRENTLOCKINGMODE

Undocumented lt_ctx_pkg.getcurrentlockingmode RETURN VARCHAR2;

SELECT lt_ctx_pkg.getcurrentlockingmode

      FROM dual;

      

      GETCURRENTLOCKINGMODE

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

      OPTIMISTIC_LOCKING

GETLTLOCKINFO

Undocumented

Demo from $ORACLE_HOME/rdbms/ admin/owmr1220.plb: Reformatted for readability lt_ctx_pkg.getltlockinfo( wm_ltlock IN VARCHAR2, info IN VARCHAR2) RETURN VARCHAR2;

CREATE OR REPLACE VIEW wmsys.wm$all_locks_view AS

      SELECT vt.owner, vt.table_name, DECODE(wmsys.lt_ctx_pkg.getltlockinfo(

                 translate(t.info USING CHAR_CS), 'ROW_LOCKMODE'), 'E', 'EXCLUSIVE',

                 'S', 'SHARED', 'VE', 'VERSION EXCLUSIVE', 'WE',

                 'WORKSPACE EXCLUSIVE') lock_mode,

                 wmsys.lt_ctx_pkg.getltlockinfo(

                 translate(t.info USING CHAR_CS), 'ROW_LOCKUSER') lock_owner,

                 wmsys.lt_ctx_pkg.getltlockinfo(

                 translate(t.info USING CHAR_CS), 'ROW_LOCKSTATE') locking_state

      FROM wmsys.wm$versioned_tables vt,

           table(wmsys.ltadm.get_lock_table(vt.owner, vt.table_name)) t

      WITH READ ONLY;

GETLTTABLENAME

Undocumented lt_ctx_pkg.getlttablename( owner_var IN VARCHAR2, table_name_var IN VARCHAR2, onlytable IN BOOLEAN) RETURN VARCHAR2;

TBD

GETMAXVTRANGE

Undocumented lt_ctx_pkg.getmaxvtrange RETURN wmsys.wm_period;

TBD

GETMULTIWORKSPACES

Undocumented

Protected by Accessible By clause lt_ctx_pkg.getmultiworkspaces RETURN VARCHAR2;

SELECT lt_ctx_pkg.getmultiworkspaces;

             *

      ORA-06553: PLS-904: insufficient privilege to access object GETMULTIWORKSPACES

GETNEXTVER

Undocumented

Overload 1 lt_ctx_pkg.getnextver(curnextver IN VARCHAR2) RETURN VARCHAR2;

TBD

Overload 2 lt_ctx_pkg.getnextver( wm_nextver IN VARCHAR2, curver IN NUMBER, parver IN NUMBER, curstate IN VARCHAR2, crstatus IN VARCHAR2, vtid IN NUMBER) RETURN VARCHAR2;

TBD

GETPARWSDELSTATUS

Undocumented lt_ctx_pkg.getparwsdelstatus(wm_ltlock IN VARCHAR2) RETURN VARCHAR2;

TBD

GETPARWSVER

Undocumented lt_ctx_pkg.getparwsver(wm_ltlock IN VARCHAR2) OUT VARCHAR2;

TBD

GETPREVVER

Undocumented lt_ctx_pkg.getprevver(wm_ltlock IN VARCHAR2) RETURN VARCHAR2;

TBD

GETPURGEOPTION

Undocumented

Protected by Accessible By clause lt_ctx_pkg.getpurgeoption RETURN VARCHAR2;

SELECT lt_ctx_pkg.getpurgeoption;

             *

      ORA-06553: PLS-904: insufficient privilege to access object GETPURGEOPTION

GETRICLOCKS

Undocumented lt_ctx_pkg.getriclocks( pt_owner IN VARCHAR2, pt_name IN VARCHAR2, slockno_v IN NUMBER, elockno_v IN NUMBER, optype IN NUMBER);

TBD

GETSESSIONATTRIBUTES

Undocumented lt_ctx_pkg.getsessionattributes( l_cid OUT VARCHAR2, l_serial# OUT VARCHAR2);

TBD

GETSTATEFROMVER

Undocumented lt_ctx_pkg.getstatefromver(in_ver IN NUMBER) RETURN VARCHAR2;

TBD

GETSTRIPPEDNEXTVER

Undocumented lt_ctx_pkg.getstrippednextver( wm_nextver IN VARCHAR2, curver IN NUMBER, parver IN NUMBER, curstate IN VARCHAR2, crstatus IN VARCHAR2, vtid IN NUMBER, state_to_strip IN VARCHAR2, mp_root_workspace IN VARCHAR2) RETURN VARCHAR2;

TBD

GETVARIABLE_B

Undocumented lt_ctx_pkg.getvariable_b(varname IN VARCHAR2) RETURN BOOLEAN;

TBD

GETVARIABLE_N

Undocumented lt_ctx_pkg.getvariable_n(varname IN VARCHAR2) RETURN NUMBER;

TBD

GETVARIABLE_V

Undocumented lt_ctx_pkg.getvariable_v(varname IN VARCHAR2) RETURN VARCHAR2;

TBD

GETVTTABLENAME

Undocumented lt_ctx_pkg.getvttablename( owner_var IN VARCHAR2, table_name_var IN VARCHAR2) RETURN VARCHAR2;

TBD

INITIALIZERICLOCKINGVARS

Undocumented lt_ctx_pkg.initializericlockingvars;

exec lt_ctx_pkg.initializericlockingvars;

      

      PL/SQL procedure successfully completed.

INSERTEXTTABROWSFORNVER

Undocumented lt_ctx_pkg.insertexttabrowsfornver( oldrowid IN UROWID, oldvalidtime IN wmsys.wm_period, newrowid IN UROWID, newnextver OUT VARCHAR2, newvalidtime IN wmsys.wm_period);

TBD

REFRESHVERSINWSPCLIST

Undocumented lt_ctx_pkg.refreshversinwspclist( curstate IN VARCHAR2, newtime IN TIMESTAMP WITH TIME ZONE);

TBD

SETACTIVETIMEFORDML

Undocumented

Overload 1 lt_ctx_pkg.setactivetimefordml( time_in IN DATE, setts IN BOOLEAN);

TBD

Overload 2 lt_ctx_pkg.setactivetimefordml(time_in IN TIMESTAMP WITH TIME ZONE);

TBD

SETCALLSTACKASINVALID

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setcallstackasinvalid;

exec lt_ctx_pkg.setcallstackasinvalid;

           *

      PLS-00904: insufficient privilege to access object SETCALLSTACKASINVALID

SETCALLSTACKASVALID

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setcallstackasvalid;

exec lt_ctx_pkg.setcallstackasvalid;

           *

      PLS-00904: insufficient privilege to access object SETCALLSTACKASVALID

SETCOMMITVARS

Undocumented lt_ctx_pkg.setcommitvars(isrefreshed IN NUMBER);

TBD

SETCOMPRESSWORKSPACE

Undocumented lt_ctx_pkg.setcompressworkspace( state_var IN VARCHAR2, beginver IN NUMBER, endver IN NUMBER, beginsp IN VARCHAR2, endsp IN VARCHAR2);

TBD

SETCONFLICTSTATE

Undocumented lt_ctx_pkg.setconflictstate( statename IN VARCHAR2, par_state IN VARCHAR2, par_ver IN NUMBER, post_ver IN NUMBER);

TBD

SETCOPYVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setcopyvars;

exec lt_ctx_pkg.setcopyvars;

           *

      PLS-00904: insufficient privilege to access object SETCOPYVARS

SETCRINFO

Undocumented lt_ctx_pkg.setcrinfo( wm_ltlock IN VARCHAR2, par_ws_ver IN NUMBER, par_ws_delstatus IN NUMBER, prev_ver IN NUMBER) RETURN VARCHAR2;

TBD

SETDIFFVERS

Undocumented lt_ctx_pkg.setdiffvers( state1 IN VARCHAR2, savepoint1 IN VARCHAR2, state2 IN VARCHAR2, savepoint2 IN VARCHAR2, onlymodified IN BOOLEAN);

TBD

SETEVCHECKPOINT

Undocumented lt_ctx_pkg.setevcheckpoint( schema IN VARCHAR2, tab_name IN VARCHAR2, opcode IN VARCHAR2, value_v IN VARCHAR2);

TBD

SETFLIPVERSIONONREFRESH

Undocumented lt_ctx_pkg.setflipversiononrefresh(code IN VARCHAR2);

TBD

SETFREEZESTATUS

Undocumented lt_ctx_pkg.setfreezestatus(code IN VARCHAR2);

TBD

SETIMPORTVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setimportvars(apply_locks_v IN BOOLEAN);

exec lt_ctx_pkg.setimportvars(TRUE);

           *

      PLS-00904: insufficient privilege to access object SETIMPORTVARS

SETINSTANT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setinstant(instant_in IN TIMESTAMP WITH TIME ZONE);

exec lt_ctx_pkg.setinstant(SYSTIMESTAMP);

           *

      PLS-00904: insufficient privilege to access object SETINSTANT

SETLOCKMODE

Undocumented lt_ctx_pkg.setlockmode( lockmode IN VARCHAR2, statewidesetting IN BOOLEAN);

TBD

SETLTLOCKINFO

Undocumented lt_ctx_pkg.setltlockinfo( wm_ltlock IN VARCHAR2, new_data IN VARCHAR2, info IN VARCHAR2) RETURN VARCHAR2;

TBD

SETMPROOT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setmproot(rootworkspace IN VARCHAR2);

exec lt_ctx_pkg.setmproot('WS_MLIB');

           *

      PLS-00904: insufficient privilege to access object SETMPROOT

SETMPWORKSPACE

Undocumented lt_ctx_pkg.setmpworkspace(mpworkspace IN VARCHAR2);

TBD

SETMULTIWORKSPACES

Undocumented lt_ctx_pkg.setmultiworkspaces(mstab IN wmsys.ltutil.wm$ident_tab_bin);

TBD

SETNEWMPVARS

Undocumented lt_ctx_pkg.setnewmpvars( mp_leaf_workspace IN VARCHAR2, mp_root_workspace IN VARCHAR2, old_root_anc_version IN NUMBER);

TBD

SETNEWROOTANCVERSION

Undocumented lt_ctx_pkg.setnewrootancversion(newrootancversion IN NUMBER);

TBD

SETOPCONTEXT

Undocumented lt_ctx_pkg.setopcontext(opcontext IN VARCHAR2);

TBD

SETPOSTVARS

Undocumented lt_ctx_pkg.setpostvars(isrefreshed IN NUMBER);

TBD

SETPREVVER

Undocumented lt_ctx_pkg.setprevver( wm_ltlock IN VARCHAR2, wm_version IN NUMBER) RETURN VARCHAR2;

TBD

SETROWLOCKSTATUS

Undocumented lt_ctx_pkg.setrowlockstatus(code IN VARCHAR2);

TBD

SETSAVEPOINT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setsavepoint(sp IN VARCHAR2);

exec lt_ctx_pkg.setsavepoint('UWSP1');

           *

      PLS-00904: insufficient privilege to access object SETSAVEPOINT

SETSTATEATTRIBUTES

Undocumented lt_ctx_pkg.setstateattributes( state_var IN VARCHAR2, parstate IN VARCHAR2, lock_id IN NUMBER, version_var IN NUMBER, parversion IN NUMBER, postversion IN NUMBER, curchangetime IN TIMESTAMP WITH TIME ZONE, isrefreshed_var IN NUMBER, l_depth IN NUMBER);

TBD

SETTABMRGWOREMOVEEVENT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.settabmrgworemoveevent;

exec lt_ctx_pkg.settabmrgworemoveevent;

           *

      PLS-00904: insufficient privilege to access object SETTABMRGWOREMOVEEVENT

SETTABMRGWREMOVEEVENT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.settabmrgwremoveevent;

exec lt_ctx_pkg.settabmrgwremoveevent;

           *

      PLS-00904: insufficient privilege to access object SETTABMRGWREMOVEEVENT

SETTABREFRESHEVENT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.settabrefreshevent;

exec lt_ctx_pkg.settabrefreshevent;

           *

      PLS-00904: insufficient privilege to access object SETTABREFRESHEVENT

SETTRIGGEREVENT

Undocumented lt_ctx_pkg.settriggerevent(triggeropctxvar IN VARCHAR2);

TBD

SETTSINSTANT

Undocumented lt_ctx_pkg.settsinstant(instant_in IN VARCHAR2);

TBD

SETUSER

Undocumented lt_ctx_pkg.setuser( cur_schema IN VARCHAR2, p_user IN VARCHAR2);

TBD

SETVALIDTIME

Undocumented lt_ctx_pkg.setvalidtime( alidfrom_var IN VARCHAR2, validtill_var IN VARCHAR2);

TBD

SETVALIDTIMEFILTEROFF

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setvalidtimefilteroff;

exec lt_ctx_pkg.setvalidtimefilteroff;

           *

      PLS-00904: insufficient privilege to access object SETVALIDTIMEFILTEROFF

SETVALIDTIMEFILTERON

Undocumented lt_ctx_pkg.setvalidtimefilteron(filtertime IN VARCHAR2);

TBD

SETVARIABLE

Undocumented lt_ctx_pkg.setvariable( varname IN VARCHAR2, value_v IN VARCHAR2, value_n IN NUMBER, value_b IN BOOLEAN);

TBD

SETVERAFTINSTANT

Undocumented lt_ctx_pkg.setveraftinstant(ver IN NUMBER);

TBD

SETVERBEFINSTANT

Undocumented lt_ctx_pkg.setverbefinstant(ver IN NUMBER);

TBD

SETVERSION

Undocumented lt_ctx_pkg.setversion(ver IN NUMBER);

TBD

SETVERSIONANDSTATE

Undocumented lt_ctx_pkg.setversionandstate( ver IN NUMBER, state_var IN VARCHAR2);

TBD

SETWRITERSTATE

Undocumented lt_ctx_pkg.setwriterstate(state IN VARCHAR2);

TBD

SETWSPCMRGWOREMOVEEVENT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setwspcmrgworemoveevent;

exec lt_ctx_pkg.setwspcmrgworemoveevent;

           *

      PLS-00904: insufficient privilege to access object SETWSPCMRGWOREMOVEEVENT

SETWSPCMRGWREMOVEEVENT

Undocumented

Protected by Accessible By clause lt_ctx_pkg.setwspcmrgwremoveevent;

exec lt_ctx_pkg.setwspcmrgwremoveevent;

           *

      PLS-00904: insufficient privilege to access object SETWSPCMRGWREMOVEEVENT

TO_TIMESTAMP_TZ_

Undocumented lt_ctx_pkg.to_timestamp_tz_( datestr IN VARCHAR2, fmt IN VARCHAR2, nlsparam IN VARCHAR2) RETURN TIMESTAMP WITH TIME ZONE;

TBD

UNSETCOMMITVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.unsetcommitvars;

exec lt_ctx_pkg.unsetcommitvars;

           *

      PLS-00904: insufficient privilege to access object UNSETCOMMITVARS

UNSETCOPYVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.unsetcopyvars;

exec lt_ctx_pkg.unsetcopyvars;

           *

      PLS-00904: insufficient privilege to access object UNSETCOPYVARS

UNSETIMPORTVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.unsetimportvars;

exec lt_ctx_pkg.unsetimportvars;

           *

      PLS-00904: insufficient privilege to access object UNSETIMPORTVARS

UNSETPOSTVARS

Undocumented

Protected by Accessible By clause lt_ctx_pkg.unsetpostvars;

exec lt_ctx_pkg.unsetpostvars;

           *

      PLS-00904: insufficient privilege to access object UNSETPOSTVARS

UPDATE_MODIFIED_TABLES

Undocumented lt_ctx_pkg.update_modified_tables( table_owner_name_var IN VARCHAR2, table_name_var IN VARCHAR2, version_var IN NUMBER, state_var IN VARCHAR2, vtid IN NUMBER);

TBD

WM$DISALLOWQNDML

Undocumented

Sample code at right from $ORACLE_HOME/rdbms/admin/ owmr1120.plb formatted for readability. lt_ctx_pkg.wm$disallowqndml RETURN NUMBER;

IF (INSTR(vrec.text, 'wmsys.lt_ctx_pkg.wm$disallowQnDML')>0) THEN

        EXECUTE IMMEDIATEe 'create or replace view ' || vrec.owner || '.' || vrec.view_name ||

        ' as ' || REPLACE(vrec.text, 'wmsys.lt_ctx_pkg.wm$disallowQnDML',

        'wmsys.wm$disallowQnDML');

      END IF;