Oracle DR_DEF
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
Coming to OpenWorld 2018? Be sure to visit the TidalScale booth in Moscone South and learn how to solve performance problems and lower costs with Software Defined Servers. Before you visit the booth, or if you can't make it this year, check out TidalScale at www.tidalscale.com. Be sure to click on the Solutions link and look through the Oracle resources.
Purpose Contains basic definitions used by all CTX components.
AUTHID DEFINER
Constants
-- Max word length for words in stop list
max_word_length CONSTANT NUMBER := 64;
Data Types -- same as drvutl.qlid2
TYPE name_TAB IS TABLE OF VARCHAR2(261) INDEX BY BINARY_INTEGER;
TYPE ID_TAB IS TABLE OF binary_integer INDEX BY BINARY_INTEGER;

TYPE pref_rec IS RECORD (
pre_id     NUMBER(38),
pre_owner  VARCHAR2(128),
pre_owner# NUMBER,
pre_name   VARCHAR2(128),
pre_obj_id NUMBER(38),
pre_cla_id NUMBER(38),
pre_valid  CHAR(1),
pre_extra1 NUMBER);

TYPE obj_rec IS RECORD (
obj_cla_id NUMBER(38),
obj_id     NUMBER(38),
obj_name   VARCHAR2(128),
obj_desc   VARCHAR2(80),
obj_system CHAR(1));

TYPE idx_rec IS RECORD (
idx_id               NUMBER(38),
idx_type             NUMBER,
idx_owner            VARCHAR2(128),
idx_owner#           NUMBER,
idx_name             VARCHAR2(128),
idx_table_owner      VARCHAR2(128),
idx_table            VARCHAR2(128),
idx_table#           NUMBER,
idx_key_name         VARCHAR2(256),
idx_key_type         NUMBER,
idx_text_name        VARCHAR2(256),
idx_text_type        NUMBER,
idx_text_length      NUMBER,
idx_docid_count      NUMBER,
idx_status           VARCHAR2(12),
idx_version          NUMBER,
idx_next_id           NUMBER,
idx_language_column  VARCHAR2(256),
idx_format_column    VARCHAR2(256),
idx_charset_column   VARCHAR2(256),
idx_config_column    VARCHAR2(256),
idx_option           VARCHAR2(64),
idx_opt_token        VARCHAR2(64),
idx_opt_type         NUMBER,
idx_opt_count        NUMBER,
idx_sync_type        VARCHAR2(20) ,
idx_sync_memory      VARCHAR2(100),
idx_sync_para_degree NUMBER,
idx_sync_interval    VARCHAR2(4000));

TYPE ixp_rec IS RECORD (
ixp_id               NUMBER(38),
ixp_name             VARCHAR2(128),
ixp_idx_id           NUMBER,
ixp_table_partition  VARCHAR2(128),
ixp_docid_count      NUMBER,
ixp_status           VARCHAR2(12),
ixp_nextid           NUMBER,
ixp_option           VARCHAR2(40),
ixp_opt_token        VARCHAR2(64),
ixp_opt_type         NUMBER,
ixp_opt_count        NUMBER,
ixp_sync_type        VARCHAR2(20),
ixp_sync_memory      VARCHAR2(100),
ixp_sync_para_degree NUMBER,
ixp_sync_interval    VARCHAR2(4000));

TYPE ixp_tab IS TABLE OF ixp_rec INDEX BY BINARY_INTEGER;

TYPE sec_rec IS RECORD (
sec_id       NUMBER,
sec_TYPE     NUMBER,
sec_tname    VARCHAR2(10),
sec_name     VARCHAR2(128),
sec_tag      VARCHAR2(256),
sec_fid      NUMBER,
sec_visible  VARCHAR2(1),
sec_datatype NUMBER,
sec_oat_id   NUMBER,
sec_readonly VARCHAR2(1));

TYPE sec_tab IS TABLE OF sec_rec INDEX BY BINARY_INTEGER;

TYPE rowid_tab IS TABLE OF rowid INDEX BY BINARY_INTEGER;

TYPE vc256_tab IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;

TYPE vc500_tab IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;

TYPE vc30_tab  IS TABLE OF VARCHAR2(30)  INDEX BY BINARY_INTEGER;

TYPE ixo_rec IS RECORD (
ixo_cla_id   NUMBER,
ixo_cla_name VARCHAR2(128),
ixo_obj_id   NUMBER,
ixo_obj_name VARCHAR2(128),
ixo_acnt     NUMBER);

TYPE ixo_tab IS TABLE OF ixo_rec INDEX BY BINARY_INTEGER;

TYPE ixv_rec IS RECORD (
ixv_oat_name VARCHAR2(128),
ixv_value    VARCHAR2(500));

TYPE ixv_tab IS TABLE OF ixv_rec INDEX BY BINARY_INTEGER;

TYPE spw_rec IS RECORD (
spw_type     VARCHAR2(10),
spw_language VARCHAR2(30),
spw_word     VARCHAR2(80),
spw_pattern  VARCHAR2(512));

TYPE spw_tab IS TABLE OF spw_rec INDEX BY BINARY_INTEGER;

TYPE slx_rec IS RECORD (
slx_language  VARCHAR2(80),
slx_lang_abbr VARCHAR2(30),
slx_alt_value VARCHAR2(30),
slx_obj_name  VARCHAR2(128),
slx_ixv       ixv_tab);

TYPE slx_tab IS TABLE OF slx_rec INDEX BY BINARY_INTEGER;

TYPE ixx_rec IS RECORD (
ixx_collist VARCHAR2(500),
ixx_storage VARCHAR2(500));

TYPE ixx_tab IS TABLE OF ixx_rec INDEX BY BINARY_INTEGER;

TYPE ixc_rec IS RECORD (
ixc_cnum  BINARY_INTEGER,
ixc_cname VARCHAR2(256),
ixc_ctype VARCHAR2(30),
ixc_clen  VARCHAR2(20));

TYPE ixc_tab IS TABLE OF ixc_rec INDEX BY BINARY_INTEGER;

TYPE cdi_rec IS RECORD (
cdi_column_position NUMBER,
cdi_column_name     VARCHAR2(256),
cdi_column_type     VARCHAR2(30),
cdi_column_type#    NUMBER,
cdi_column_length   NUMBER,
cdi_section_name    VARCHAR2(128),
cdi_section_type    VARCHAR2(5),
cdi_section_id      NUMBER,
cdi_sort_order      VARCHAR2(8));

TYPE cdi_tab IS TABLE OF cdi_rec INDEX BY BINARY_INTEGER;
Dependencies
 
Documented No
Exceptions
Error Code Reason
None textile_error EXCEPTION;
First Available Not known
Security Model Owned by CTXSYS with no privileges granted
Source {ORACLE_HOME}/ctx/admin/drig.pkh

Related Topics
Built-in Functions
Built-in Packages
DRIG
DRILIST
DRIOBJ
What's New In 12cR1
What's New In 12cR2

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