Oracle LTUTIL
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 Utilities
AUTHID DEFINER
Data Types TYPE CONS_VIOLATION_TAB ....;

TYPE NUMBER_TAB ....;

TYPE NUMBER_TAB_BIN ....;

TYPE ROWID_WCT ....;

TYPE VARCHAR2_TAB_4000_BIN ....;

TYPE WM$FULL_IDENT_TAB ....;

TYPE WM$IDENT_TAB ....;

TYPE WM$IDENT_TAB_BIN ....;
Dependencies SELECT name FROM dba_dependencies WHERE referenced_name = 'LTUTIL' UNION
SELECT referenced_name FROM dba_dependencies WHERE name = 'LTUTIL' ORDER BY 1;

Returns 179 objects
Documented No
Exceptions
Error Code Reason
ORA-00904 "LTUTIL"."GETWORKSPACELOCKMODE": invalid identifier
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/owmutls.plb
{ORACLE_HOME}/rdbms/admin/owmutlb.plb
Subprograms
ADDUSERDEFINEDHINT GETDEFAULTWORKSPACEID INSERTNEXTVERS
ADDWCP GETDEFAULTWORKSPACENAME INSERTVERSION
ALLOCATE_UNIQUE GETDESCVERSIONS INVERSIONEDSTATE
ALLOWROWLEVELLOCKING GETDISTINCTOBJECT ISIMPLICITSP
BITCLEAR GETDISVER ISLEAFSTATE
BITOR GETHISTOPTION ISMODIFIED
BUMPYUPPER GETINDEXTABLE ISMODIFIEDINSUBTREE
CHECKADDTOPOGEOLAYERERRORS GETINDEXTABLESPACE ISOBJECTTABLE
CHECKDELTOPOGEOLAYERERRORS GETMINWORKSPACEVERSION ISSPATIALINSTALLED
CHECKDOMAININDEXPRIVS GETNESTEDCOLUMNVIEW ISSPLITINSUBTREE
CHOOSE GETNESTEDTABLECOLSTR ISTOPOFEATURETABLE
CLEANUPBDDL GETNESTEDTABLEMETADATACOLUMNS ISTOPOLOGYINDEXTABLE
CLEANUPCDDL GETNESTEDTABLETYPE ISTOPOLOGYRELATIONTABLE
CLEANUPDV GETNEXTVERSION ISVERSIONEDTABLE
CLEANUPEV GETNOTNULLCONSTRAINT ISVERSIONENABLEDTOPOLOGY
CLEANUPMETADATA GETNTPKEYCOLS ISWORKSPACEOWNER
CLEANUPMETADATABYUSER GETPIPELINEDTABLE MOVEWMMETADATA
CLEANUPSTALEMETADATA GETPKEYCOLS NEEDTOEXECUTETRIGGERS
CONTRACTWHITESPACE GETPKEYINFO NUMTRIGGERSTOEXECUTE
CONTRACTWHITESPACECLOB GETPKEYINFO_VT PARSESTRINGLIST
COPYRLSPOLICIES GETPKINDEXINFO PIPED_ROWID_FUNC
CREATEINLISTFROMQUERY GETRICSTATUS POPULATEROWIDRANGES
CREATEPKWHERECLAUSE GETRLSWHERECLAUSE PREFIXSTR
DELETEFULLROLLBACKMARKER GETSEQUENCEOPTIONS QB_BLOCK_REPLACE
DELETEUNDOCODE GETSID RECOMPUTEALLVTROWIDS
DELETEUNDOCODERANGE GETSNO REMOVEUSERDEFINEDHINT
DELETE_ALL_SDO_GEOM_METADATA GETSPACEUSAGE RENAMESAVEPOINT
DISALLOWIFWITHVT GETSTATEFROMVER RENAMEWORKSPACE
DROPRLSPOLICIES GETTABLETABLESPACE REQUIRESTRIGGERSONTOPVIEW
DROPUNUSEDCOLUMNS GETTOPOFEATURETABINFO RESETALLSEQUENCES
EXECEVUNDO GETTOPOINFO RESOLVESYNONYM
EXECLOG GETTRIGFLAG RESTARTSEQUENCE
EXECUTESQLLOG GETTRIGGERS ROLLBACKTOTXNSAVEPOINT
EXISTSBIR GETTRIGTYPES ROWSINVERSFROMHISTOGRAM
EXISTSBUR GETUDHINT SEPARATECLOBINTO2PARTS
EXISTSCONSTRAINT GETUNDOCODECLOB SETDEBUGOPTIONS
EXISTSFULLROLLBACKMARKER GETVALIDTIMEOPTION SETDISVER
EXISTSTOPOLOGY GETVARIABLE_R SETTXNSAVEPOINT
FIXTOPOLOGYIMPORT GETVERINDEXNAME SETVARIABLE
FIXVTAB_COMPRESS GETVN SKIPOBJECTSDURINGEXPORT
FIXVTAB_REFRESH GETVTID STRIPVERSION
FIXVTAB_ROLLBACK GETWHERECLAUSESTR STRIPVERSIONRANGE
GENFIXCRNONSEQNFRESHINS GETWORKSPACELOCKID STUFFVERSION
GENWMCOLSUPDATESTMNT GETWORKSPACELOCKMODE STUFFVERSIONRANGE
GETBASETABLENAME GET_EXPANDED_NEXTVERS SUBSVERSION
GETBATCHWHERECLAUSES GET_EXPANDED_NEXTVERS_NP TOPOTABLECHECK
GETCOLINFO GRANTOLSPRIVS TO_CLOB_
GETCOLLIST HASCRCHILD UPDATESDOTOPOMETADATADV
GETCOLSTR HASDEFERREDCHILD UPDATESDOTOPOMETADATAEV
GETCOLUMNDECLARATION HASFEATURETABLE VT_FIXNVTAB
GETCOLUMNPLUSEXPRESSION HASNESTEDTABLECOLUMN WM$CONCAT
GETCONTAINEDVER HASOLSPOLICY WM$CONVERTVERSIONSTR
GETCONTAINEDVERINRANGE HASRICCASCADINGCONSTRAINT WM$GETDBCOMPATIBLESTR
GETCONTAINEDVERSINWORKSPACE HASRICSETNULLCONSTRAINT WM$GETDBVERSIONSTR
GETCONTAINEDVERSIONRANGE HASVIRTUALCOLUMN WM$GETERRORS
GETCRNEXTVERS HASWOOVERWRITEOPTION WM$SORTSTRING
GETCRSTATUS HISTWITHDATETYPE WRITETOLOG
GETCURRENTLOCKINGMODE HISTWITHDATETYPEEV WRITEUNDOCODE
GETCURVER INSERTFULLROLLBACKMARKER  
 
ADDUSERDEFINEDHINT
Undocumented ltutil.addUserDefinedHint(
hint_id_var IN NUMBER,
hint        IN VARCHAR2,
schema      IN VARCHAR2,
tab_name    IN VARCHAR2);
TBD
 
ADDWCP
Undocumented ltutil.addwcp(
wc           IN VARCHAR2,
before_after IN VARCHAR2,
conjunction  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
ALLOCATE_UNIQUE
Undocumented ltutil.allocate_unique(
lockname   IN  VARCHAR2,
lockhandle OUT VARCHAR2);
TBD
 
ALLOWROWLEVELLOCKING
Undocumented ltutil.allowrowlevellocking(
state  IN VARCHAR2,
opcode IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
BITCLEAR
Undocumented ltutil.bitclear(
val1 IN NUMBER,
val2 IN NUMBER)
RETURN NUMBER;
SELECT wmsys.ltutil.bitclear(6,2);

WMSYS.LTUTIL.BITCLEAR(6,2)
--------------------------
                         4
 
BITOR
Undocumented ltutil.bitor(
val1 IN NUMBER,
val2 IN NUMBER)
RETURN NUMBER;
SELECT wmsys.ltutil.bitor(7,8);

WMSYS.LTUTIL.BITCLEAR(7,8)
--------------------------
                        15
 
BUMPYUPPER (new 23ai)
Undocumented

I cannot help but feel that several people should have lost their jobs over this. Well maybe not lost their jobs, just forced to read the docs cover to cover.		 ltutil.bumpyUpper(name IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.ltutil.bumpyUpper('da Morgan');

WMSYS.LTUTIL.BUMPYUPPER(DAMORGAN)
-----------------------------------
DA MORGAN

SELECT UPPER('da Morgan');

UPPER(DAMORGAN)
-----------------------------------
DA MORGAN
 
CHECKADDTOPOGEOLAYERERRORS
Undocumented ltutil.checkaddtopogeolayererrors(
topology_owner           IN VARCHAR2,
topology                 IN VARCHAR2,
table_owner_var          IN VARCHAR2,
table_name_var           IN VARCHAR2,
column_name              IN VARCHAR2,
topo_geometry_layer_type IN VARCHAR2);
TBD
 
CHECKDELTOPOGEOLAYERERRORS
Undocumented ltutil.checkdeltopogeolayererrors(
topology_owner  IN VARCHAR2,
topology        IN VARCHAR2,
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
column_name     IN VARCHAR2);
TBD
 
CHECKDOMAININDEXPRIVS
Undocumented ltutil.checkdomainindexprivs(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2);
TBD
 
CHOOSE
Testing indicates that FALSE selects the first string, TRUE the second. ltutil.choose(
str1 IN VARCHAR2,
str2 IN VARCHAR2,
flag IN BOOLEAN)
RETURN VARCHAR2;
DECLARE
 retVal dbms_id;
BEGIN
  retVal := wmsys.ltutil.choose('Daniel', 'Morgan', FALSE);
  dbms_output.put_line(retVal);
  retVal := wmsys.ltutil.choose('Daniel', 'Morgan', TRUE);
  dbms_output.put_line(retVal);
END;
/
Daniel
Morgan

PL/SQL procedure successfully completed.
 
CLEANUPBDDL
Undocumented ltutil.cleanupbddl(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
CLEANUPCDDL
Undocumented ltutil.cleanupcddl(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
resetdisver       IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
CLEANUPDV
Undocumented ltutil.cleanupdv(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
CLEANUPEV
Undocumented ltutil.cleanupev(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
CLEANUPMETADATA
Undocumented ltutil.cleanupmetadata(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2);
TBD
 
CLEANUPMETADATABYUSER
Protected by an ACCESSIBLE BY clause ltutil.cleanupmetadatabyuser(schema IN VARCHAR2);
exec wmsys.ltutil.cleanupmetadatabyuser('C##TESTUSER');
     *
PLS-00904: insufficient privilege to access object CLEANUPMETADATABYUSER
 
CLEANUPSTALEMETADATA
Protected by an ACCESSIBLE BY clause ltutil.cleanupstalemetadata;
exec wmsys.ltutil.cleanupstalemetadata;
     *
PLS-00904: insufficient privilege to access object CLEANUPSTALEMETADATA
 
CONTRACTWHITESPACE
All 4 examples, at right contain a total of 5 spaces (CHR 32). In the second demo the leading spaces are reduced from 4 to 1 ltutil.contractwhitespace(str IN VARCHAR2) RETURN VARCHAR2;
SELECT LENGTH(wmsys.ltutil.contractwhitespace('Morgan''s     Library'));

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         20

SELECT LENGTH(wmsys.ltutil.contractwhitespace('    Morgan''s Library'));

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         17

SELECT LENGTH(wmsys.ltutil.contractwhitespace('Morgan''s Library    '));

LENGTH(WMSYS.LTUTIL.CONTRACTWHITESPACE('MORGAN''SLIBRARY'))
-----------------------------------------------------------
                                                         20
 
CONTRACTWHITESPACECLOB
Undocumented ltutil.contractwhitespaceclob(c IN CLOB) RETURN CLOB;
DECLARE
 InVal  CLOB := 'x                    x                    x';
 retVal CLOB;
BEGIN
  retVal := wmsys.ltutil.contractwhitespaceclob(inVal);
  dbms_output.put_line(LENGTH(retVal));
END;
/
5

PL/SQL procedure successfully completed.
 
COPYRLSPOLICIES
Undocumented ltutil.copyrlspolicies(
source_owner IN VARCHAR2,
source_name  IN VARCHAR2,
target_owner IN VARCHAR2,
target_name  IN VARCHAR2,
log_undo     IN BOOLEAN);
TBD
 
CREATEINLISTFROMQUERY
Undocumented ltutil.createinlistfromquery(
sqlstr  IN VARCHAR2,
using_t IN wmsys.ltutil.wm$full_ident_tab,
maxs    IN NUMBER)
RETURN VARCHAR2;
TBD
 
CREATEPKWHERECLAUSE
Undocumented ltutil.createpkwhereclause(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
DELETEFULLROLLBACKMARKER
Undocumented ltutil.deletefullrollbackmarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
DELETEUNDOCODE
Undocumented ltutil.deleteundocode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
index_type_var  IN NUMBER,
index_var       IN NUMBER);
TBD
 
DELETEUNDOCODERANGE
Undocumented ltutil.deleteundocoderange(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
minvalue        IN NUMBER,
maxvalue        IN NUMBER);
TBD
 
DELETE_ALL_SDO_GEOM_METADATA
Undocumented ltutil.delete_all_sdo_geom_metadata(
owner           IN VARCHAR2,
old_table_name  IN VARCHAR2,
old_column_name IN VARCHAR2);
TBD
 
DISALLOWIFWITHVT
Undocumented ltutil.disallowifwithvt(
owner_name_var IN VARCHAR2,
table_name_var IN VARCHAR2,
operation_name IN VARCHAR2);
TBD
 
DROPRLSPOLICIES
Undocumented ltutil.droprlspolicies(
source_owner IN VARCHAR2,
source_name  IN VARCHAR2);
TBD
 
DROPUNUSEDCOLUMNS
Undocumented ltutil.dropunusedcolumns(
table_owner IN VARCHAR2,
table_name  IN VARCHAR2);
TBD
 
EXECEVUNDO
Undocumented ltutil.execevundo(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
opcode            IN VARCHAR2);
TBD
 
EXECLOG
Undocumented ltutil.execlog(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN,
state_var         IN VARCHAR2,
operationvar      IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
EXECUTESQLLOG
Undocumented ltutil.executesqllog(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
ignore_last_error IN BOOLEAN);
TBD
 
EXISTSBIR
Undocumented ltutil.existsbir(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSBUR
Undocumented ltutil.existsbur(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSCONSTRAINT
Undocumented ltutil.existsconstraint(
table_owner_var     IN VARCHAR2,
table_name_var      IN VARCHAR2,
constraint_name_var IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSFULLROLLBACKMARKER
Undocumented ltutil.existsfullrollbackmarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
EXISTSTOPOLOGY
Undocumented ltutil.existstopology(
topo_owner_var IN VARCHAR2,
topo_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
FIXTOPOLOGYIMPORT
Undocumented ltutil.fixtopologyimport(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
FIXVTAB_COMPRESS
Undocumented ltutil.fixvtab_compress(
instate  IN VARCHAR2,
startver IN NUMBER,
endver   IN NUMBER);
TBD
 
FIXVTAB_REFRESH
Undocumented ltutil.fixvtab_refresh(
rfh_state IN VARCHAR2,
parstate  IN VARCHAR2,
parver    IN NUMBER);
TBD
 
FIXVTAB_ROLLBACK
Undocumented ltutil.fixvtab_rollback(
instate IN VARCHAR2,
cpver   IN NUMBER);
TBD
 
GENFIXCRNONSEQNFRESHINS
Undocumented ltutil.genFixCrnonSeqnFreshins(
schemaname        IN VARCHAR2,
tab_name          IN VARCHAR2,
targetcurver      IN NUMBER,
pkey_cols         IN VARCHAR2,
pkey_where_clause IN VARCHAR2,
pkey_params       IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GENWMCOLSUPDATESTMNT
Undocumented ltutil.genWMColsUpdateStmnt(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
histoption    IN VARCHAR2,
vt_option     IN NUMBER,
vtrange       IN wmsys.wm_period,
undospace     IN VARCHAR2);
TBD
 
GETBASETABLENAME
Undocumented ltutil.getbasetablename(
tab_owner IN     VARCHAR2,
tab_name  IN OUT VARCHAR2,
bv           OUT BOOLEAN);
TBD
 
GETBATCHWHERECLAUSES
Undocumented ltutil.getbatchwhereclauses(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN wmsys.ltutil.varchar2_tab_4000_bin;
TBD
 
GETCOLINFO
Undocumented ltutil.getcolinfo(
owner_name          IN  VARCHAR2,
tab_name            IN  VARCHAR2,
col_names           OUT VARCHAR2,
pkey_col_type_decls OUT VARCHAR2,
pkey_col_names      OUT VARCHAR2);
TBD
 
GETCOLLIST
Undocumented ltutil.getcollist(
owner_name       IN  VARCHAR2,
tab_name         IN  VARCHAR2,
col_names        OUT VARCHAR2,
col_names_no_pfx OUT VARCHAR2);
TBD
 
GETCOLSTR
Undocumented ltutil.getcolstr(
schema          IN VARCHAR2,
tab_name        IN VARCHAR2,
prefix_str      IN VARCHAR2,
include_virtual IN NUMBER,
exclude_all_wm  IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETCOLUMNDECLARATION
Undocumented ltutil.getcolumndeclaration(
datatype_owner IN VARCHAR2,
datatype       IN VARCHAR2,
datatype_mod   IN VARCHAR2,
l_length       IN NUMBER,
l_char_length  IN NUMBER,
l_char_used    IN VARCHAR2,
l_precision    IN NUMBER,
l_scale        IN NUMBER,
l_data_default  IN LONG,
resolve_synonym IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETCOLUMNPLUSEXPRESSION
Undocumented ltutil.getcolumnplusexpression(
indowner IN VARCHAR2,
indname  IN VARCHAR2,
indtype  IN VARCHAR2,
colname  IN VARCHAR2,
colpos   IN NUMBER,
descend  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCONTAINEDVER
Undocumented ltutil.getContainedver(
in_nextver        IN VARCHAR2,
instate           IN VARCHAR2,
mp_root_workspace IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETCONTAINEDVERINRANGE
Undocumented ltutil.getContainedverinRange(
in_nextver IN VARCHAR2,
tab_name   IN VARCHAR2,
instate    IN VARCHAR2,
beginver   IN NUMBER,
endver     IN NUMBER)
RETURN NUMBER;
TBD
 
GETCONTAINEDVERSINWORKSPACE
Undocumented ltutil.getContainedversinWorkspace(
in_nextver        IN VARCHAR2,
instate           IN ARCHAR2,
mp_root_workspace IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCONTAINEDVERSIONRANGE
Undocumented ltutil.getContainedVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETCRNEXTVERS
Undocumented ltutil.getcrNextVers(
curver     IN     NUMBER,
oldnextver IN OUT VARCHAR2,
newnextver IN OUT VARCHAR2);
TBD
 
GETCRSTATUS
Undocumented ltutil.getcrStatus(workspace_var IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETCURRENTLOCKINGMODE
Undocumented ltutil.getCurrentLockingMode RETURN VARCHAR2;
SELECT wmsys.ltutil.getCurrentLockingMode;
       *
ORA-06553: PLS-904: insufficient privilege to access object GETCURRENTLOCKINGMODE
 
GETCURVER
Undocumented ltutil.getCurVer RETURN NUMBER;
SELECT wmsys.ltutil.getCurVer;
       *
ORA-06553: PLS-904: insufficient privilege to access object GETCURVER
 
GETDEFAULTWORKSPACEID
Undocumented ltutil.getDefaultWorkspaceid RETURN NUMBER;
SELECT wmsys.ltutil.getDefaultWorkspaceid;

GETDEFAULTWORKSPACEID
---------------------
                    0
 
GETDEFAULTWORKSPACENAME
Undocumented ltutil.getDefaultWorkspaceName RETURN VARCHAR2;
SELECT wmsys.ltutil.getDefaultWorkspaceName;

GETDEFAULTWORKSPACENAME
------------------------
LIVE
 
GETDESCVERSIONS
Undocumented ltutil.getdescversions(
curver           IN  NUMBER,
wm$dvtabversions OUT wmsys.ltutil.number_tab,
wm$dvtabdescvers OUT wmsys.ltutil.number_tab,
fromcurwspc      IN BOOLEAN);
TBD
 
GETDISTINCTOBJECT
Undocumented ltutil.getdistinctobject(schema IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GETDISVER
Undocumented ltutil.getdisver(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETHISTOPTION
Undocumented ltutil.gethistoption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETINDEXTABLE
Undocumented ltutil.getindextable(
feature_owner IN  VARCHAR2,
feature_name  IN  VARCHAR2,
column_name   IN  VARCHAR2,
index_owner   OUT VARCHAR2,
index_table   OUT VARCHAR2);
TBD
 
GETINDEXTABLESPACE
Undocumented ltutil.getindextablespace(
index_owner_var IN VARCHAR2,
index_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETMINWORKSPACEVERSION
Undocumented ltutil.getminworkspaceversion(workspace_var IN VARCHAR2) RETURN NUMBER;
TBD
 
GETNESTEDCOLUMNVIEW
Undocumented ltutil.getnestedcolumnview(
tab_owner        IN VARCHAR2,
tab_name         IN VARCHAR2,
colstr           IN VARCHAR2,
view_name        IN VARCHAR2,
where_clause     IN VARCHAR2,
lt_view_tab_name IN VARCHAR2,
prefixed_colstr  IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLECOLSTR
Undocumented ltutil.getnestedtablecolstr(
l_type_owner IN VARCHAR2,
l_type_name  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLEMETADATACOLUMNS
Undocumented ltutil.getnestedtablemetadatacolumns(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNESTEDTABLETYPE
Undocumented ltutil.getnestedtabletype(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN VARcHAR2;
TBD
 
GETNEXTVERSION
Undocumented ltutil.getnextversion RETURN NUMBER;
SELECT wmsys.ltutil.getnextversion;
       *
ORA-06553: PLS-904: insufficient privilege to access object GETNEXTVERSION
 
GETNOTNULLCONSTRAINT
Undocumented ltutil.getnotnullconstraint(
tab_owner IN VARCHAR2,
tab_name  IN VARCHAR2,
colname   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETNTPKEYCOLS
Undocumented ltutil.getntpkeycols(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETPIPELINEDTABLE
Undocumented ltutil.getpipelinedtable(
fmode IN NUMBER,
nval1 IN NUMBER,
nval2 IN NUMBER,
vval1 IN VARCHAR2,
vval2 IN VARCHAR2)
RETURN wmsys.wm$exp_map_tab;
TBD
 
GETPKEYCOLS
Undocumented ltutil.getpkeycols(
schema          IN VARCHAR2,
tab_name        IN VARCHAR2,
include_virtual IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETPKEYINFO
Undocumented ltutil.getpkeyinfo(
schema      IN  VARCHAR2,
tab_name    IN  VARCHAR2,
pkindexname OUT VARCHAR2,
pkcols      OUT VARCHAR2);
TBD
 
GETPKEYINFO_VT
Undocumented ltutil.getpkeyinfo_vt(
schema                 IN  VARCHAR2,
tab_name               IN  VARCHAR2,
pkey_cols              OUT VARCHAR2,
pkey_cols_nv           OUT VARCHAR2,
pkey_cols_noprefix     OUT VARCHAR2,
pkey_cols_nv_noprefix  OUT VARCHAR2,
pkey_col_decls         OUT VARCHAR2,
pkey_col_vals          OUT VARCHAR2,
pkey_col_vals_idx      OUT VARCHAR2,
pkey_where_clause_fins OUT VARCHAR2,
pkey_params_fins       OUT VARCHAR2,
join_clause1           OUT VARCHAR2,
join_clause2           OUT VARCHAR2,
oj_join_clause         OUT VARCHAR2,
join_clause_fins       OUT VARCHAR2,
pkey_col_decls_fins    OUT VARCHAR2,
pkey_col_vals_fins     OUT VARCHAR2,
pkey_col_vals_idx_fins OUT VARCHAR2);
TBD
 
GETPKINDEXINFO
Undocumented ltutil.getpkindexinfo(
table_owner_var IN  VARCHAR2,
table_name_var  IN  VARCHAR2,
pkidxowner      OUT VARCHAR2,
pkidxname       OUT VARCHAR2);
TBD
 
GETRICSTATUS
Undocumented ltutil.getricstatus(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETRLSWHERECLAUSE
Undocumented ltutil.getrlswhereclause(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETSEQUENCEOPTIONS
Undocumented ltutil.getsequenceoptions(
seqowner IN VARCHAR2,
seqname  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETSID
Undocumented ltutil.getsid(curusid IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSNO
Undocumented ltutil.getsno(curusid IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSPACEUSAGE
Undocumented ltutil.getspaceusage(schema_name IN VARCHAR2) RETURN NUMBER;
TBD
 
GETSTATEFROMVER
Undocumented ltutil.getstatefromver(in_ver IN NUMBER) RETURN VARCHAR2;
TBD
 
GETTABLETABLESPACE
Undocumented ltutil.gettabletablespace(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETTOPOFEATURETABINFO
Undocumented ltutil.gettopofeaturetabinfo(
table_owner_var      IN  VARCHAR2,
table_name_var       IN  VARCHAR2,
topology_owner_var   OUT VARCHAR2,
topology_name_var    OUT VARCHAR2,
topoindextableowners OUT wmsys.ltutil.wm$ident_tab,
topoindextablenames  OUT wmsys.ltutil.wm$ident_tab,
topogeocolnames      OUT wmsys.ltutil.wm$ident_tab);
TBD
 
GETTOPOINFO
Undocumented ltutil.gettopoinfo(
topo_owner_var IN  VARCHAR2,
topo_name_var  IN  VARCHAR2,
tol_var        OUT NUMBER,
srid_var       OUT NUMBER,
ub_var         OUT NUMBER,
lb_var         OUT NUMBER);
TBD
 
GETTRIGFLAG
Undocumented ltutil.gettrigflag(v IN VARCHAR2) RETURN NUMBER;
TBD
 
GETTRIGGERS
Undocumented ltutil.gettriggers(
table_owner  IN VARCHAR2,
table_name   IN VARCHAR2,
triggerevent IN NUMBER,
trig_type    IN VARCHAR2)
RETURN REF_CURSOR;
TBD
 
GETTRIGTYPES
Undocumented ltutil.gettrigtypes(val IN NUMBER) RETURN VARCHAR2;
TBD
 
GETUDHINT
Undocumented ltutil.getudhint(
hint_id_var     IN NUMBER,
tab_owner_v     IN VARCHAR2,
tab_name_v      IN VARCHAR2,
table_list      IN VARCHAR2,
additional_hint IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETUNDOCODECLOB
Undocumented ltutil.getundocodeclob(
table_owner      IN VARCHAR2,
table_name       IN VARCHAR2,
descending_order IN BOOLEAN)
RETURN REF CURSOR;
TBD
 
GETVALIDTIMEOPTION
Undocumented ltutil.getvalidtimeoption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETVARIABLE_R
Undocumented ltutil.getVariable_r(varname IN VARCHAR2) RETURN wmsys.ltutil.rowid_wct;
TBD
 
GETVERINDEXNAME
Undocumented ltutil.getVerIndexName(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
GETVN
Undocumented ltutil.getvn(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
ext             IN VARCHAR2,
vtid            IN NUMBER)
RETURN VARCHAR2;
TBD
 
GETVTID
Undocumented ltutil.getvtid(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN NUMBER;
TBD
 
GETWHERECLAUSESTR
Undocumented ltutil.getWhereClauseStr(
str        IN VARCHAR2,
prfx1      IN VARCHAR2,
prfx2      IN VARCHAR2,
outer_join IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
GETWORKSPACELOCKID
Undocumented ltutil.getWorkspaceLockid(workspace_var IN VARCHAR2) RETURN NUMBER;
TBD
 
GETWORKSPACELOCKMODE
Undocumented ltutil.getWorkspaceLockMode(workspace_var IN VARCHAR2) RETURN VARCHAR2;
TBD
 
GET_EXPANDED_NEXTVERS
Undocumented ltutil.get_expanded_nextvers(curr_nv IN VARCHAR2) RETURN wmsys.wm$nextver_exp_tab_type;
TBD
 
GET_EXPANDED_NEXTVERS_NP
Undocumented ltutil.get_expanded_nextvers_np(curr_nv IN VARCHAR2) RETURN wmsys.wm$nextver_exp_tab_type;
TBD
 
GRANTOLSPRIVS
Protected by an ACCESSIBLE BY clause ltutil.grantOLSprivs(policy_name IN VARCHAR2);
TBD
 
HASCRCHILD
Undocumented ltutil.hasCRChild(parent_workspace_var IN VARCHAR2) RETURN BOOLEAN;
TBD
 
HASDEFERREDCHILD
Undocumented ltutil.hasDeferredChild(state IN VARCHAR2) RETURN BOOLEAN;
TBD
 
HASFEATURETABLE
Undocumented ltutil.hasFeatureTable(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASNESTEDTABLECOLUMN
Undocumented ltutil.hasNestedTableColumn(
owner_name IN VARCHAR2,
tab_name   IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASOLSPOLICY
Protected by an ACCESSIBLE BY clause ltutil.hasOLSpolicy(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASRICCASCADINGCONSTRAINT
Undocumented ltutil.hasricCascadingConstraint(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASRICSETNULLCONSTRAINT
Undocumented ltutil.hasricSetNullConstraint(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASVIRTUALCOLUMN
Undocumented ltutil.hasVirtualColumn(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HASWOOVERWRITEOPTION
Undocumented ltutil.haswooverWriteOption(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HISTWITHDATETYPE
Undocumented ltutil.histWithDateType(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
HISTWITHDATETYPEEV
Undocumented ltutil.histWithDateYypeev(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
INSERTFULLROLLBACKMARKER
Undocumented ltutil.insertFullRollbackMarker(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2);
TBD
 
INSERTNEXTVERS
Undocumented ltutil.insertNextVers(
newnextver IN VARCHAR2,
split      IN NUMBER);
TBD
 
INSERTVERSION
Undocumented

Overload 1		 ltutil.insertVersion(wm_nextver IN VARCHAR2) RETURN VARCHAR2;
TBD
Undocumented

Overload 2		 ltutil.insertVersion(
wm_nextver IN  VARCHAR2,
curver     IN  NUMBER,
parver     IN  NUMBER,
curstate   IN  VARCHAR2,
crstatus   IN  VARCHAR2,
in_vtid    IN  NUMBER,
parnextver OUT VARCHAR2,
curnextver OUT VARCHAR2);
TBD
 
INVERSIONEDSTATE
Undocumented ltutil.inVersionedState(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISIMPLICITSP
Undocumented ltutil.isImplicitsp(
workspace_name IN VARCHAR2,
savepoint_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISLEAFSTATE
Undocumented ltutil.isLeafState(
state_id       IN NUMBER,
cpver          IN NUMBER,
mp_check       IN BOOLEAN,
deferred_check IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
ISMODIFIED
Undocumented ltutil.isModified(
table_owner_var   IN VARCHAR2,
table_name_var    IN VARCHAR2,
state_name        IN VARCHAR2,
version_num       IN NUMBER,
checkwithequality IN BOOLEAN,
mp_root_workspace IN VARCHAR2,
oper_type         IN NUMBER,
leaf_workspace    IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISMODIFIEDINSUBTREE
Undocumented ltutil.isModifiedInsubtree(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
state_name      IN VARCHAR2,
checksubtree    IN BOOLEAN,
querytable      IN BOOLEAN)
RETURN BOOLEAN;
TBD
 
ISOBJECTTABLE
Returns TRUE if the table is an object table, else FALSE ltutil.isObjectTable(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISSPATIALINSTALLED
Undocumented ltutil.isSpatialInstalled(topo IN BOOLEAN) RETURN BOOLEAN;
TBD
 
ISSPLITINSUBTREE
Undocumented ltutil.isSplitInsubtree(state_name IN VARCHAR2) RETURN BOOLEAN;
TBD
 
ISTOPOFEATURETABLE
Undocumented ltutil.isTopoFeatureTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISTOPOLOGYINDEXTABLE
Undocumented ltutil.isTopologyIndexTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISTOPOLOGYRELATIONTABLE
Undocumented ltutil.isTopologyRelationTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISVERSIONEDTABLE
Undocumented ltutil.isVersionedTable(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISVERSIONENABLEDTOPOLOGY
Undocumented ltutil.isVersionEnabledTopology(
topo_owner IN VARCHAR2,
topology   IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
ISWORKSPACEOWNER
Undocumented ltutil.isWorkspaceOwner(
user_name     IN VARCHAR2,
workspace_var IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
MOVEWMMETADATA
Undocumented ltutil.moveWMmetadata(new_tablespace IN VARCHAR2);
TBD
 
NEEDTOEXECUTETRIGGERS
Undocumented ltutil.needToExecuteTriggers(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
triggerevent    IN NUMBER,
trig_type       IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
NUMTRIGGERSTOEXECUTE
Undocumented ltutil.numTriggersToExecute(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
triggerevent    IN NUMBER,
trig_type       IN VARCHAR2)
RETURN NUMBER;
TBD
 
PARSESTRINGLIST
Undocumented ltutil.parseStringList(
str     IN  VARCHAR2,
tab1    OUT wmsys.ltutil.wm$ident_tab,
tab2    OUT wmsys.ltutil.wm$ident_tab,
delim1  IN  VARCHAR2,
delim2  IN  VARCHAR2,
defval2 IN  VARCHAR2);
TBD
 
PIPED_ROWID_FUNC
Undocumented ltutil.piped_rowid_func(rowidtab IN wmsys.wm$ident_tab_type)
RETURN wmsys.wm$ident_tab_type;
TBD
 
POPULATEROWIDRANGES
Undocumented ltutil.populateRowidRanges(
table_owner_v IN VARCHAR2,
table_name_v  IN VARCHAR2,
undospace     IN VARCHAR2);
TBD
 
PREFIXSTR
Protected by an ACCESSIBLE BY clause ltutil.prefixStr(
prfx IN VARCHAR2,
str  IN VARCHAR2)
RETURN VARCHAR2;
SELECT wmsys.ltutil.prefixStr('Professor ', 'Morgan');
       *
ORA-06553: PLS-904: insufficient privilege to access object PREFIXSTR
 
QB_BLOCK_REPLACE
Undocumented ltutil.qb_block_replace(str IN VARCHAR2) RETURN VARCHAR2;
TBD
 
RECOMPUTEALLVTROWIDS(new 23ai)
Undocumented ltutil.recomputeAllVTRowids(vtid IN NUMBER);
TBD
 
REMOVEUSERDEFINEDHINT
Undocumented ltutil.removeUserDefinedHint(
hint_id_var IN NUMBER,
schema      IN VARCHAR2,
tab_name    IN VARCHAR2);
TBD
 
RENAMESAVEPOINT
Note that the parameters and usage are exactly the same as the DBMS_WM procedure of the same name ltutil.renameSavepoint(
workspace_name     IN VARCHAR2,
old_savepoint_name IN VARCHAR2,
new_savepoint_name IN VARCHAR2);
exec dbms_wm.renamesavepoint('WS1', 'SP1', 'SP_FIRST');
 
RENAMEWORKSPACE
Note that the parameters and usage are exactly the same as the DBMS_WM procedure of the same name ltutil.renameWorkspace(
old_workspace_name IN VARCHAR2,
new_workspace_name IN VARCHAR2);
exec dbms_wm.renameWorkspace('ws1', 'wsFirst');
 
REQUIRESTRIGGERSONTOPVIEW
Undocumented ltutil.requiresTriggersonTopView(
schema   IN VARCHAR2,
tab_name IN VARCHAR2)
RETURN BOOLEAN;
TBD
 
RESETALLSEQUENCES
Protected by an ACCESSIBLE BY clause ltutil.resetAllSequences(importoperation IN BOOLEAN);
exec wmsys.ltutil.resetAllSequences(TRUE);
     *
PLS-00904: insufficient privilege to access object RESETALLSEQUENCES
 
RESOLVESYNONYM
Undocumented ltutil.resolveSynonym(
owner_var IN OUT VARCHAR2,
name_var  IN OUT VARCHAR2);
TBD
 
RESTARTSEQUENCE
Protected by an ACCESSIBLE BY clause ltutil.restartSequence(
seq_owner IN VARCHAR2,
seq_name  IN VARCHAR2,
value_v   IN NUMBER);
CREATE SEQUENCE testseq;

SELECT testseq.NEXTVAL;

/

/

/

/

exec wmsys.ltutil.restartSequence(USER, 'TESTSEQ', 1);
*
PLS-00904: insufficient privilege to access object RESTARTSEQUENCE
 
ROLLBACKTOTXNSAVEPOINT
Undocumented ltutil.rollbackToTxnSavepoint;
exec wmsys.ltutil.rollbacktotxnsavepoint;

PL/SQL procedure successfully completed.
 
ROWSINVERSFROMHISTOGRAM
Undocumented ltutil.rowsInversFromHistogram(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
workspace_var   IN VARCHAR2,
beginver        IN NUMBER,
endver          IN NUMBER,
colname         IN VARCHAR2,
returnpercent   IN BOOLEAN)
RETURN NUMBER;
TBD
 
SEPARATECLOBINTO2PARTS
Protected by an ACCESSIBLE BY clause ltutil.separateClobInto2parts(
c   IN  CLOB,
s1  OUT VARCHAR2,
s2  OUT VARCHAR2,
len IN  NUMBER);
DECLARE
 inVal   CLOB := 'The Quick Brown Fox Jumped Over The Lazy Programmer';
 outVal1 dbms_id;
 outVal2 dbms_id;
BEGIN
  wmsys.ltutil.separateclobinto2parts(inVal, outVal1, outVal2, 10);
  dbms_output.put_line(outVal1);
  dbms_output.put_line(outVal2);
END;
/
*
PLS-00904: insufficient privilege to access object SEPARATECLOBINTO2PARTS
 
SETDEBUGOPTIONS
Undocumented ltutil.setDebugOptions(
debug_option IN VARCHAR2,
param1       IN VARCHAR2);
TBD
 
SETDISVER
Undocumented ltutil.setdisver(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
disver          IN VARCHAR2)
TBD
 
SETTXNSAVEPOINT
Creates a transaction save point. ltutil.settxnsavepoint;
exec wmsys.ltutil.settxnsavepoint;

PL/SQL procedure successfully completed.
 
SETVARIABLE
Undocumented ltutil.setvariable(
varname IN VARCHAR2,
value_r IN wmsys.ltutil.rowid_wct);
TBD
 
SKIPOBJECTSDURINGEXPORT
Undocumented ltutil.skipobjectsduringexport(
tab_owner_v IN VARCHAR2,
tab_name_v  IN VARCHAR2,
vtid        IN NUMBER,
fmode_v     IN VARCHAR2,
buffercode  IN BOOLEAN);
TBD
 
STRIPVERSION
Undocumented ltutil.stripVersion(
wm_nextver IN VARCHAR2,
curver     IN VARCHAR2,
noinsert   IN BOOLEAN)
RETURN VARCHAR2;
TBD
 
STRIPVERSIONRANGE
Undocumented ltutil.stripVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
STUFFVERSION
Undocumented ltutil.stuffVersion(
wm_nextver IN VARCHAR2,
curver     IN NUMBER)
RETURN VARCHAR2;
TBD
 
STUFFVERSIONRANGE
Undocumented ltutil.stuffVersionRange(
wm_nextver    IN VARCHAR2,
version_range IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
SUBSVERSION
Undocumented ltutil.subsVersion(
wm_nextver IN VARCHAR2,
cur_vers   IN VARCHAR2,
subs_ver   IN VARCHAR2)
RETURN VARCHAR2;
TBD
 
TOPOTABLECHECK
Undocumented ltutil.topoTableCheck(
table_owners IN wmsys.ltutil.wm$ident_tab,
table_names  IN wmsys.ltutil.wm$ident_tab,
fmode        IN VARCHAR2);
TBD
 
TO_CLOB_
Protected by an ACCESSIBLE BY clause ltutil.to_clob_(text IN VARCHAR2) RETURN CLOB;
DECLARE
 retVal CLOB;
BEGIN
  retVal := wmsys.ltutil.to_clob_('Test string');
  dbms_output.put_line(retVal);
END;
/
*
PLS-00904: insufficient privilege to access object TO_CLOB_
 
UPDATESDOTOPOMETADATADV
Undocumented ltutil.updateSDOtopometadatadv(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
UPDATESDOTOPOMETADATAEV
Undocumented ltutil.updateSDOtopometadataev(
topo_owner IN VARCHAR2,
topo_name  IN VARCHAR2);
TBD
 
VT_FIXNVTAB
Undocumented ltutil.vt_fixnvtab(
sourcestate       IN VARCHAR2,
targetstate       IN VARCHAR2,
targetcurver      IN NUMBER,
tab_owner         IN VARCHAR2,
tab_name          IN VARCHAR2,
operation         IN VARCHAR2,
docrcheck         IN BOOLEAN,
mp_root_workspace IN VARCHAR2);
TBD
 
WM$CONCAT
Undocumented ltutil.wm$concat(strs IN wmsys.wm$ident_tab_type) RETURN CLOB;
TBD
 
WM$CONVERTVERSIONSTR
No reason to believe the demo at right is what was intended but it does give an indication of how it might be used ltutil.wm$convertversionstr(version_str IN VARCHAR2) RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$convertversionstr('19.3.0.0');

WMSYS.LTUTIL.WM$CONVERTVERSIONSTR('19.3.0.0')
----------------------------------------------------
J.3.0.0

SELECT wmsys.ltutil.wm$convertversionstr('12.1.0.2');

WMSYS.LTUTIL.WM$CONVERTVERSIONSTR('12.1.0.2')
----------------------------------------------------
C.1.0.2
 
WM$GETDBCOMPATIBLESTR
Protected by an ACCESSIBLE BY clause ltutil.wm$getdbcompatiblestr RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$getdbcompatiblestr;
       *
ORA-06553: PLS-904: insufficient privilege to access object WM$GETDBCOMPATIBLESTR
 
WM$GETDBVERSIONSTR
Undocumented ltutil.wm$getdbversionstr RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$getdbversionstr;

WM$GETDBVERSIONSTR
-------------------
J.0.0.0.0
 
WM$GETERRORS
Undocumented ltutil.wm$geterrors RETURN wmsys.wm$exp_map_tab;
TBD
 
WM$SORTSTRING
This is an amazing function. Given a delimited string and the delimiting character it alpha sorts the values and returns them with the same delimiter. ltutil.wm$sortstring(
str       IN VARCHAR2,
delimiter IN VARCHAR2)
RETURN VARCHAR2;
SELECT wmsys.ltutil.wm$sortstring('A|Z|B|Y|C|X', '|');

WMSYS.LTUTIL.WM$SORTSTRING('A|Z|B|Y|C|X','|')
----------------------------------------------
A|B|C|X|Y|Z
 
WRITETOLOG
Undocumented

Overload 1		 ltutil.writeToLog(str IN VARCHAR2);
exec wmsys.ltutil.writeToLog('Test Write');
     *
PLS-00904: insufficient privilege to access object WRITETOLOG
Undocumented

Overload 2		 ltutil.writeToLog(cstr IN CLOB);
TBD
 
WRITEUNDOCODE
Undocumented

Overload 1		 ltutil.writeUndoCode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
undocode        IN VARCHAR2,
index_type_var  IN NUMBER,
execuser        IN VARCHAR2);
TBD
Undocumented

Overload 2		 ltutil.writeUndoCode(
table_owner_var IN VARCHAR2,
table_name_var  IN VARCHAR2,
undocode        IN CLOB,
index_type_var  IN NUMBER,
execuser        IN VARCHAR2);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_WM
LT
LTAQ
LTDDL
LTDTRG
LTI
LTPRIV
LTRIC
OWM_ASSERT_PKG
OWM_BULK_LOAD_PKG
OWM_CPKG_PKG
OWM_DDL_PKG
OWM_DYNSQL_ACCESS
OWM_IEXP_PKG
OWM_MIG_PKG
OWM_MP_PKG
OWM_VSCRIPT_PKG
OWM_VT_PKG
WM_DDL_UTIL
What's New In 21c
What's New In 26ai

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