Oracle CTX_TREE
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
Purpose Undocumented
AUTHID CURRENT_USER
Dependencies
DBMS_ASSERT DRIXMD DRVUTL
DBMS_STANDARD DRUE DRVXMD
DRIG DRVDDL DRVXTAB
DRILIST DRVDISP DR_DEF
DRISGP DRVDOC PLITBLM
DRIUTL    
Documented No
First Available Not known
Security Model Owned by CTXSYS with EXECUTE granted to the CTXAPP role.
Source {ORACLE_HOME}/ctx/admin/dr0tree.pkh
Subprograms
 
ADD_NODE
Adds a new node to a tree associated with a MVDATA section and index ctx_tree.add_node.add_node(
index_name   IN  VARCHAR2,
section_name IN  VARCHAR2,
path         IN  CLOB,
id_list      OUT CLOB,
force        IN  BOOLEAN DEFAULT FALSE);
PRAGMA SUPPLEMENTAL_LOG_DATA(add_node, AUTO);
TBD
 
DROPSEQUENCES
Undocumented ctx_tree.dropSequences(
idx_owner IN VARCHAR2,
idx_name  IN VARCHAR2,
idx_id    IN NUMBER);
TBD
 
GET_CHILDREN
Looks up the children names of the node identified by a path in a tree associated with a MVDATA section and index ctx_tree.get_children(
index_name   IN     VARCHAR2,
section_name IN     VARCHAR2,
path         IN     CLOB,
child_list   IN OUT CLOB);
TBD
 
GET_NODEID_LIST
Looks up the node identifiers of all nodes in an existing path in a tree associated with a MVDATA section and index ctx_tree.get_nodeid_list(
index_name   IN     VARCHAR2,
section_name IN     VARCHAR2,
path         IN     CLOB,
id_list      IN OUT CLOB);
TBD
 
GET_NODE_ID
Looks up the node identifier of an existing path in a tree associated with a MVDATA section and index ctx_tree.get_node_id(
index_name   IN  VARCHAR2,
section_name IN  VARCHAR2,
path         IN  CLOB,
id           OUT INTEGER) ;
TBD
 
GET_ROOTS
Looks up the roots of all the trees associated with a MVDATA section and index ctx_tree.get_roots(
index_name   IN  VARCHAR2,
section_name IN  VARCHAR2,
roots        OUT CLOB);
TBD
 
REGINDEX
Undocumented ctx_tree.regIndex(
index_name IN VARCHAR2,
purge      IN BOOLEAN);
TBD
 
REGISTER_INDEX
Registers an index with the CTX_TREE package ctx_tree.register_index(index_name IN VARCHAR2);
PRAGMA SUPPLEMENTAL_LOG_DATA(register_index, AUTO);
exec ctxsys.ctx_tree.register_index('C##UWCLASS.IX_UWDOM");
 
REMOVE_NODE
Removes specified node from the tree associated with the MVDATA section and Index ctx_tree.remove_node(
index_name   IN VARCHAR2,
section_name IN VARCHAR2,
path         IN CLOB);
PRAGMA SUPPLEMENTAL_LOG_DATA(remove_node, AUTO);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
CTX_ADM
CTX_ANL
CTX_CATSEARCH
CTX_CLS
CTX_DDL
CTX_ENTITY
CTX_OUTPUT
CTX_REPORT
CTX_ULEXER
CTX_XPCONTAINS
What's New In 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx