| Data Types |
SUBTYPE dr_id IS dbms_id_128; /* use: id */
SUBTYPE dr_id2 IS VARCHAR2(257); /* use: id.id */
SUBTYPE dr_id3 IS VARCHAR2(386); /* use: id.id.id */
SUBTYPE dr_qid IS dbms_quoted_id_128; /* use: quoted id */
SUBTYPE dr_qid2 IS VARCHAR2(261); /* use: qid.qid */
SUBTYPE dr_qid3 IS VARCHAR2(392); /* use: qid.qid.qid */
SUBTYPE dr_lid IS dbms_id_128; /* use: long id lid */
SUBTYPE dr_lid2 IS VARCHAR2(257); /* use: lid.lid */
SUBTYPE dr_lid3 IS VARCHAR2(386); /* use: lid.lid.lid */
SUBTYPE dr_qlid IS dbms_quoted_id_128; /* use: quoted long id qlid */
SUBTYPE dr_qlid2 IS VARCHAR2(261); /* use: qlid.qlid */
SUBTYPE dr_qlid3 IS VARCHAR2(392); /* use: qlid.qlid.qlid */
SUBTYPE dr_longpart IS VARCHAR2(403); /* use: qlid.qlid partition(qlid)*/
SUBTYPE dr_shortbuf IS VARCHAR2(32); /* use: small scratch buff */
SUBTYPE dr_medbuf IS VARCHAR2(128); /* use: medium scratch buff */
SUBTYPE dr_longbuf IS VARCHAR2(512); /* use: long scratch buff */
SUBTYPE dr_extrabuf IS VARCHAR2(4000); /* use: 4000 bytes */
SUBTYPE dr_maxbuf IS VARCHAR2(32767); /* use: max len allowed */
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_nextid
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(255),
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)); |