93:
94: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
95: -- drop the existing preferences
96: BEGIN
97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
95: -- drop the existing preferences
96: BEGIN
97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
97: ctx_ddl.drop_preference(ctx_pref_datastore);
98: xErrLoc := 110;
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
99: ctx_ddl.drop_preference('ICX_CAT_FILTER');
100: xErrLoc := 120;
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);
101: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
102: xErrLoc := 125;
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);
108: xErrLoc := 170;
109: EXCEPTION
103: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
104: xErrLoc := 140;
105: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
106: xErrLoc := 150;
107: ctx_ddl.drop_section_group(ctx_section_group);
108: xErrLoc := 170;
109: EXCEPTION
110: WHEN OTHERS THEN
111: null;
112: END;
113:
114: xErrLoc := 200;
115: -- create preferences
116: ctx_ddl.create_preference(ctx_pref_datastore, 'DETAIL_DATASTORE');
117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;
115: -- create preferences
116: ctx_ddl.create_preference(ctx_pref_datastore, 'DETAIL_DATASTORE');
117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;
117: xErrLoc := 210;
118: -- Set the attributes specific to DETAIL_DATASTORE.
119: ctx_ddl.set_attribute(ctx_pref_datastore, 'binary', 'false');
120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');
120: xErrLoc := 211;
121: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_table',
122: xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_TLP');
123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;
123: xErrLoc := 212;
124: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_key',
125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;
125: 'rt_item_id, language');
126: xErrLoc := 213;
127: ctx_ddl.set_attribute(ctx_pref_datastore, 'detail_lineno', 'sequence');
128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
128: xErrLoc := 214;
129: ctx_ddl.set_attribute(ctx_pref_datastore,'detail_text', 'CTX_DESC');
130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
130:
131: xErrLoc := 220;
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');
132: ctx_ddl.create_preference('ICX_CAT_FILTER', 'NULL_FILTER');
133: xErrLoc := 230;
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');
139:
140: -- Bug 1802907, zxzhang, May-24-01
134: ctx_ddl.create_preference('ICX_CAT_WORDLIST', 'BASIC_WORDLIST');
135: xErrLoc := 240;
136: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'STEMMER', 'AUTO');
137: xErrLoc := 260;
138: ctx_ddl.set_attribute('ICX_CAT_WORDLIST', 'FUZZY_MATCH', 'AUTO');
139:
140: -- Bug 1802907, zxzhang, May-24-01
141: -- Enabled the storage clause to have the index created in
142: -- the INDEX tablespace
140: -- Bug 1802907, zxzhang, May-24-01
141: -- Enabled the storage clause to have the index created in
142: -- the INDEX tablespace
143: xErrLoc := 270;
144: ctx_ddl.create_preference('ICX_CAT_STORAGE', 'BASIC_STORAGE');
145:
146: -- sosingha bug 3175547 to use AD API for getting the tablespace
147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN
145:
146: -- sosingha bug 3175547 to use AD API for getting the tablespace
147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN
149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
147: -- Check if the tablespace exists before using it
148: IF (check_tspace_exist = 'Y') THEN
149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
149: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_TABLE_CLAUSE',
150: 'tablespace '||ctx_data_tbsp);
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
151: ctx_ddl.set_attribute('ICX_CAT_STORAGE','K_TABLE_CLAUSE',
152: 'tablespace '||ctx_data_tbsp);
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',
153: ctx_ddl.set_attribute('ICX_CAT_STORAGE','R_TABLE_CLAUSE',
154: 'tablespace '||ctx_data_tbsp);
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',
160: 'tablespace '||ctx_index_tbsp);
161: END IF;
155: ctx_ddl.set_attribute('ICX_CAT_STORAGE','N_TABLE_CLAUSE',
156: 'tablespace '||ctx_data_tbsp);
157: ctx_ddl.set_attribute('ICX_CAT_STORAGE','P_TABLE_CLAUSE',
158: 'tablespace '||ctx_data_tbsp);
159: ctx_ddl.set_attribute('ICX_CAT_STORAGE','I_INDEX_CLAUSE',
160: 'tablespace '||ctx_index_tbsp);
161: END IF;
162:
163:
161: END IF;
162:
163:
164: xErrLoc := 280;
165: ctx_ddl.create_section_group(ctx_section_group, 'basic_section_group');
166: xErrLoc := 290;
167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:
163:
164: xErrLoc := 280;
165: ctx_ddl.create_section_group(ctx_section_group, 'basic_section_group');
166: xErrLoc := 290;
167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
167: ctx_ddl.add_field_section(ctx_section_group, 'SEARCH_TYPE',
168: 'SEARCH_TYPE', FALSE);
169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
169:
170: xErrLoc := 300;
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
171: ctx_ddl.add_field_section(ctx_section_group, 'supid',
172: 'supid', FALSE);
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;
173: ctx_ddl.add_field_section(ctx_section_group, 'catid',
174: 'catid', FALSE);
175: ctx_ddl.add_field_section(ctx_section_group, 'orgid',
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;
180: ctx_ddl.add_zone_section(ctx_section_group, 'catnm',
181: 'catnm' );
176: 'orgid', FALSE);
177: ctx_ddl.add_field_section(ctx_section_group, 'language',
178: 'language', FALSE);
179: xErrLoc := 310;
180: ctx_ddl.add_zone_section(ctx_section_group, 'catnm',
181: 'catnm' );
182:
183: FOR counter in 1..100
184: LOOP
183: FOR counter in 1..100
184: LOOP
185: xErrLoc := 320;
186: ctx_desc_tag := counter;
187: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),
188: ctx_desc_tag);
189: END LOOP;
190:
191: FOR counter in 1000..1300
191: FOR counter in 1000..1300
192: LOOP
193: xErrLoc := 330;
194: ctx_desc_tag := counter;
195: ctx_ddl.add_zone_section(ctx_section_group, to_char(counter),
196: ctx_desc_tag);
197: END LOOP;
198:
199: FOR counter in 5000..5150
200: LOOP
201: xErrLoc := 340;
202: -- OEX_IP_PORTING
203: ctx_desc_tag := counter;
204: ctx_ddl.add_zone_section(ctx_section_group,to_char(counter),
205: ctx_desc_tag);
206: END LOOP;
207:
208:
207:
208:
209: xErrLoc := 400;
210: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
211: ctx_ddl.create_preference('ICX_CAT_LEXER_GLOBAL', 'MULTI_LEXER');
212:
213: xErrLoc := 420;
214: FOR language_row IN installed_languages_csr LOOP
215: xLang := language_row.language_code;
220:
221: -- drop the existing preference
222: BEGIN
223: xErrLoc := 450;
224: ctx_ddl.drop_preference(ctx_pref_lexer);
225: xErrLoc := 460;
226: EXCEPTION
227: WHEN OTHERS THEN
228: null;
232: -- create preferences
233: if (xLang IN ('US', 'GB')) then
234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
233: if (xLang IN ('US', 'GB')) then
234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
234: -- American English (US), English (GB)
235: xErrLoc := 3490;
236: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then
237: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
238: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
239: xErrLoc := 495;
240: -- bug1898152, jingyu. Treat accented characters as regular ones.
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then
243: -- Japanese (JA)
244: xErrLoc := 500;
245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
241: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
242: elsif (xLang = 'JA') then
243: -- Japanese (JA)
244: xErrLoc := 500;
245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
246: elsif (xLang = 'KO') then
247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
245: ctx_ddl.create_preference(ctx_pref_lexer, 'JAPANESE_VGRAM_LEXER');
246: elsif (xLang = 'KO') then
247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
247: -- Korean (KO)
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
248: xErrLoc := 410;
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
249: ctx_ddl.create_preference(ctx_pref_lexer, 'KOREAN_MORPH_LEXER');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
250: xErrLoc := 520;
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
251: ctx_ddl.set_attribute(ctx_pref_lexer, 'VERB_ADJECTIVE', 'TRUE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
252: ctx_ddl.set_attribute(ctx_pref_lexer, 'ONE_CHAR_WORD', 'TRUE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
253: ctx_ddl.set_attribute(ctx_pref_lexer, 'NUMBER', 'TRUE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
254: ctx_ddl.set_attribute(ctx_pref_lexer, 'USER_DIC', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
255: ctx_ddl.set_attribute(ctx_pref_lexer, 'STOP_DIC', 'TRUE');
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
256: ctx_ddl.set_attribute(ctx_pref_lexer, 'COMPOSITE', 'COMPONENT_WORD');
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
257: ctx_ddl.set_attribute(ctx_pref_lexer, 'MORPHEME', 'TRUE');
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;
258: ctx_ddl.set_attribute(ctx_pref_lexer, 'TO_UPPER', 'TRUE');
259: ctx_ddl.set_attribute(ctx_pref_lexer, 'HANJA', 'FALSE');
260: ctx_ddl.set_attribute(ctx_pref_lexer, 'LONG_WORD', 'FALSE');
261: ctx_ddl.set_attribute(ctx_pref_lexer, 'JAPANESE', 'FALSE');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;
266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
262: ctx_ddl.set_attribute(ctx_pref_lexer, 'ENGLISH', 'TRUE');
263: elsif (xLang IN ('ZHS', 'ZHT')) then
264: -- Simplified Chinese (ZHS), Traditional Chinese (ZHT)
265: xErrLoc := 530;
266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
266: ctx_ddl.create_preference(ctx_pref_lexer, 'CHINESE_VGRAM_LEXER');
267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
267: elsif (xLang IN ('F', 'FRC')) then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
268: -- French (F), Canadian French (FRC)
269: xErrLoc := 540;
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)
270: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
271: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
272: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
273: -- bug1898152, jingyu. Treat accented characters as regular ones.
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
274: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
275: elsif (xLang = 'D') then
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
276: -- German (D)
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
277: xErrLoc := 550;
278: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
279: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
280: ctx_ddl.set_attribute(ctx_pref_lexer, 'ALTERNATE_SPELLING', 'GERMAN');
281: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
282: -- bug1898152, jingyu. Treat accented characters as regular ones.
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
283: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
284: elsif (xLang = 'I') then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
285: -- Italian (I)
286: xErrLoc := 560;
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
287: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
288: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
289: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
290: -- bug1898152, jingyu. Treat accented characters as regular ones.
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
291: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
292: elsif (xLang in ('E','ESA')) then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
293: -- Spanish (E)
294: xErrLoc := 570;
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
295: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
296: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
297: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
298: -- bug1898152, jingyu. Treat accented characters as regular ones.
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
299: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
300: elsif (xLang = 'NL') then
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
301: -- Dutch (NL)
302: xErrLoc := 580;
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
303: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
304: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
305: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
306: -- bug1898152, jingyu. Treat accented characters as regular ones.
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
307: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
308: else
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
309: -- All other languages
310: xErrLoc := 4590;
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:
311: ctx_ddl.create_preference(ctx_pref_lexer, 'BASIC_LEXER');
312: ctx_ddl.set_attribute(ctx_pref_lexer, 'INDEX_THEMES', 'NO');
313: ctx_ddl.set_attribute(ctx_pref_lexer, 'PRINTJOINS', '-_');
314: -- bug1898152, jingyu. Treat accented characters as regular ones.
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:
318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,
315: ctx_ddl.set_attribute(ctx_pref_lexer, 'BASE_LETTER', 'YES');
316: end if;
317:
318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,
320: ctx_pref_lexer);
321: if (language_row.installed_flag = 'B') then
322: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', 'default',
323: ctx_pref_lexer);
318: -- Bug 2249721, Multi-Lexer, ZXZHANG, Mar-04-02
319: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', xNLSLang,
320: ctx_pref_lexer);
321: if (language_row.installed_flag = 'B') then
322: ctx_ddl.add_sub_lexer('ICX_CAT_LEXER_GLOBAL', 'default',
323: ctx_pref_lexer);
324: end if;
325:
326: END LOOP;
384: xErrLoc := 100;
385:
386: -- drop the existing preferences
387: BEGIN
388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
386: -- drop the existing preferences
387: BEGIN
388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
388: ctx_ddl.drop_preference(ctx_pref_datastore);
389: xErrLoc := 110;
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
390: ctx_ddl.drop_preference('ICX_CAT_FILTER');
391: xErrLoc := 120;
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);
392: ctx_ddl.drop_preference('ICX_CAT_LEXER_GLOBAL');
393: xErrLoc := 125;
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);
399: xErrLoc := 170;
400: EXCEPTION
394: ctx_ddl.drop_preference('ICX_CAT_WORDLIST');
395: xErrLoc := 140;
396: ctx_ddl.drop_preference('ICX_CAT_STORAGE');
397: xErrLoc := 150;
398: ctx_ddl.drop_section_group(ctx_section_group);
399: xErrLoc := 170;
400: EXCEPTION
401: WHEN OTHERS THEN
402: NULL;
408: ctx_pref_lexer := 'ICX_CAT_LEXER_' || language_row.language_code;
409:
410: BEGIN
411: xErrLoc := 210;
412: ctx_ddl.drop_preference(ctx_pref_lexer);
413: EXCEPTION
414: WHEN OTHERS THEN
415: NULL;
416: END;
447: BEGIN
448: xErrLoc := 100;
449: -- bug 1663129: to avoid deadlock
450: -- bug 1854624: calling ctxsys.ICX_CAT_index_rebuild....
451: ad_ctx_ddl.sync_index(xIcxSchemaName||'.ICX_CAT_ITEMS_CTX_DESC');
452: xErrLoc := 200;
453:
454: EXCEPTION
455: WHEN OTHERS THEN