1 package dr_def as
2
3 -- exceptions used by all components
4 textile_error EXCEPTION;
5 -- Max word length for words in stop list
6 max_word_length CONSTANT NUMBER := 64;
7
8 type NAME_TAB is table of varchar2(60) index by binary_integer;
9 type ID_TAB is table of binary_integer index by binary_integer;
10
11 type pref_rec is record (
12 pre_id number(38)
13 , pre_owner varchar2(30)
14 , pre_owner# number
15 , pre_name varchar2(30)
16 , pre_obj_id number(38)
17 , pre_cla_id number(38)
18 , pre_valid char(1)
19 , pre_extra1 number
20 );
21
22 type obj_rec is record (
23 obj_cla_id number(38)
24 , obj_id number(38)
25 , obj_name varchar2(30)
26 , obj_desc varchar2(80)
27 , obj_system char(1)
28 );
29
30 type idx_rec is record (
31 IDX_ID NUMBER(38)
32 , IDX_TYPE NUMBER
33 , IDX_OWNER VARCHAR2(30)
34 , IDX_OWNER# NUMBER
35 , IDX_NAME VARCHAR2(30)
36 , IDX_TABLE_OWNER VARCHAR2(30)
37 , IDX_TABLE VARCHAR2(30)
38 , IDX_TABLE# NUMBER
39 , IDX_KEY_NAME VARCHAR2(256)
40 , IDX_KEY_TYPE NUMBER
41 , IDX_TEXT_NAME VARCHAR2(256)
42 , IDX_TEXT_TYPE NUMBER
43 , IDX_TEXT_LENGTH NUMBER
44 , IDX_DOCID_COUNT NUMBER
45 , IDX_STATUS VARCHAR2(12)
46 , IDX_VERSION NUMBER
47 , IDX_NEXTID NUMBER
48 , IDX_LANGUAGE_COLUMN VARCHAR2(256)
49 , IDX_FORMAT_COLUMN VARCHAR2(256)
50 , IDX_CHARSET_COLUMN VARCHAR2(256)
51 , IDX_CONFIG_COLUMN VARCHAR2(256)
52 , IDX_OPTION VARCHAR2(40)
53 , IDX_OPT_TOKEN VARCHAR2(64)
54 , IDX_OPT_TYPE NUMBER
55 , IDX_OPT_COUNT NUMBER
56 , IDX_SYNC_TYPE VARCHAR2(20)
57 , IDX_SYNC_MEMORY VARCHAR2(100)
58 , IDX_SYNC_PARA_DEGREE NUMBER
59 , IDX_SYNC_INTERVAL VARCHAR2(4000)
60 );
61
62 type ixp_rec is record (
63 IXP_ID NUMBER(38)
64 , IXP_NAME VARCHAR2(30)
65 , IXP_IDX_ID NUMBER
66 , IXP_TABLE_PARTITION VARCHAR2(30)
67 , IXP_DOCID_COUNT NUMBER
68 , IXP_STATUS VARCHAR2(12)
69 , IXP_NEXTID NUMBER
70 , IXP_OPTION VARCHAR2(40)
71 , IXP_OPT_TOKEN VARCHAR2(64)
72 , IXP_OPT_TYPE NUMBER
73 , IXP_OPT_COUNT NUMBER
74 , IXP_SYNC_TYPE VARCHAR2(20)
75 , IXP_SYNC_MEMORY VARCHAR2(100)
76 , IXP_SYNC_PARA_DEGREE NUMBER
77 , IXP_SYNC_INTERVAL VARCHAR2(4000)
78 );
79
80 type ixp_tab is table of ixp_rec index by binary_integer;
81
82 type sec_rec is record (
83 sec_id number,
84 sec_type number,
85 sec_tname varchar2(10),
86 sec_name varchar2(30),
87 sec_tag varchar2(256),
88 sec_fid number,
89 sec_visible varchar2(1),
90 sec_datatype number,
91 sec_oat_id number,
92 sec_readonly varchar2(1)
93 );
94
95 type sec_tab is table of sec_rec index by binary_integer;
96
97 type rowid_tab is table of rowid index by binary_integer;
98
99 type vc256_tab is table of varchar2(256) index by binary_integer;
100 type vc500_tab is table of varchar2(500) index by binary_integer;
101 type vc30_tab is table of varchar2(30) index by binary_integer;
102
103 type ixo_rec is record (
104 ixo_cla_id number,
105 ixo_cla_name varchar2(30),
106 ixo_obj_id number,
107 ixo_obj_name varchar2(30),
108 ixo_acnt number
109 );
110
111 type ixo_tab is table of ixo_rec index by binary_integer;
112
113 type ixv_rec is record (
114 ixv_oat_name varchar2(30),
115 ixv_value varchar2(500)
116 );
117
118 type ixv_tab is table of ixv_rec index by binary_integer;
119
120 type spw_rec is record (
121 spw_type varchar2(10),
122 spw_language varchar2(30),
123 spw_word varchar2(80),
124 spw_pattern varchar2(512)
125 );
126
127 type spw_tab is table of spw_rec index by binary_integer;
128
129 type slx_rec is record (
130 slx_language varchar2(80),
131 slx_lang_abbr varchar2(30),
132 slx_alt_value varchar2(30),
133 slx_obj_name varchar2(30),
134 slx_ixv ixv_tab
135 );
136
137 type slx_tab is table of slx_rec index by binary_integer;
138
139 type ixx_rec is record (
140 ixx_collist varchar2(500),
141 ixx_storage varchar2(500)
142 );
143
144 type ixx_tab is table of ixx_rec index by binary_integer;
145
146 type ixc_rec is record (
147 ixc_cnum binary_integer,
148 ixc_cname varchar2(256),
149 ixc_ctype varchar2(30),
150 ixc_clen varchar2(20)
151 );
152
153 type ixc_tab is table of ixc_rec index by binary_integer;
154
155 type cdi_rec is record (
156 cdi_column_position number,
157 cdi_column_name varchar2(256),
158 cdi_column_type varchar2(30),
159 cdi_column_type# number,
160 cdi_column_length number,
161 cdi_section_name varchar2(30),
162 cdi_section_type varchar2(5),
163 cdi_section_id number,
164 cdi_sort_order varchar2(8)
165 );
166
167 type cdi_tab is table of cdi_rec index by binary_integer;
168
169 end dr_def;