| 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; |