DBA Data[Home] [Help]

APPS.DOM_DOC_TEXT_PVT dependencies on AD_CTX_DDL

Line 207: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);

203: FOR multi_lexer_rec IN ( SELECT pre_owner, pre_name
204: FROM ctxsys.ctx_preferences
205: WHERE pre_name = 'DOM_DOC_MULTI_LEXER' )
206: LOOP
207: ad_ctx_ddl.drop_preference (multi_lexer_rec.pre_owner ||'.'|| multi_lexer_rec.pre_name);
208: END LOOP;
209:
210: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
211: FROM ctxsys.ctx_preferences

Line 214: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);

210: FOR sub_lexer_rec IN ( SELECT pre_owner, pre_name
211: FROM ctxsys.ctx_preferences
212: WHERE pre_name LIKE 'DOM_DOC_LEXER%' )
213: LOOP
214: ad_ctx_ddl.drop_preference (sub_lexer_rec.pre_owner ||'.'|| sub_lexer_rec.pre_name);
215: END LOOP;
216:
217: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
218: FROM ctxsys.ctx_preferences

Line 221: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);

217: FOR wordlist_rec IN ( SELECT pre_owner, pre_name
218: FROM ctxsys.ctx_preferences
219: WHERE pre_name = 'DOM_DOC_WORDLIST' )
220: LOOP
221: ad_ctx_ddl.drop_preference (wordlist_rec.pre_owner ||'.'|| wordlist_rec.pre_name);
222: END LOOP;
223:
224: FOR stoplist_rec IN ( SELECT spl_owner, spl_name
225: FROM ctxsys.ctx_stoplists

Line 228: ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.DOM_DOC_STOPLIST');

224: FOR stoplist_rec IN ( SELECT spl_owner, spl_name
225: FROM ctxsys.ctx_stoplists
226: WHERE spl_name = 'DOM_DOC_STOPLIST' )
227: LOOP
228: ad_ctx_ddl.Drop_Stoplist (stoplist_rec.spl_owner || '.DOM_DOC_STOPLIST');
229: END LOOP;
230:
231: FOR section_group_rec IN ( SELECT sgp_owner, sgp_name
232: FROM ctxsys.ctx_section_groups

Line 235: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);

231: FOR section_group_rec IN ( SELECT sgp_owner, sgp_name
232: FROM ctxsys.ctx_section_groups
233: WHERE sgp_name = 'DOM_DOC_SECTION_GROUP' )
234: LOOP
235: ad_ctx_ddl.Drop_Section_Group (section_group_rec.sgp_owner ||'.'|| section_group_rec.sgp_name);
236: END LOOP;
237:
238: FOR datastore_rec IN ( SELECT pre_owner, pre_name
239: FROM ctxsys.ctx_preferences

Line 242: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);

238: FOR datastore_rec IN ( SELECT pre_owner, pre_name
239: FROM ctxsys.ctx_preferences
240: WHERE pre_name = 'DOM_DOC_DATASTORE' )
241: LOOP
242: ad_ctx_ddl.drop_preference (datastore_rec.pre_owner ||'.'|| datastore_rec.pre_name);
243: END LOOP;
244:
245: FOR storage_rec IN ( SELECT pre_owner, pre_name
246: FROM ctxsys.ctx_preferences

Line 249: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);

245: FOR storage_rec IN ( SELECT pre_owner, pre_name
246: FROM ctxsys.ctx_preferences
247: WHERE pre_name = 'DOM_DOC_STORAGE' )
248: LOOP
249: ad_ctx_ddl.drop_preference (storage_rec.pre_owner ||'.'|| storage_rec.pre_name);
250: END LOOP;
251:
252: ------------------------------
253: -- Create STORAGE preference

Line 279: ad_ctx_ddl.create_preference (g_Pref_Owner || '.DOM_DOC_STORAGE', 'BASIC_STORAGE');

275:
276:
277: Log_Line (l_api_name || ': creating STORAGE preference ...');
278:
279: ad_ctx_ddl.create_preference (g_Pref_Owner || '.DOM_DOC_STORAGE', 'BASIC_STORAGE');
280:
281: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
282: 'I_TABLE_CLAUSE', tspace_tbl_param);
283:

Line 281: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

277: Log_Line (l_api_name || ': creating STORAGE preference ...');
278:
279: ad_ctx_ddl.create_preference (g_Pref_Owner || '.DOM_DOC_STORAGE', 'BASIC_STORAGE');
280:
281: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
282: 'I_TABLE_CLAUSE', tspace_tbl_param);
283:
284: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
285: 'K_TABLE_CLAUSE', tspace_tbl_param);

Line 284: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

280:
281: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
282: 'I_TABLE_CLAUSE', tspace_tbl_param);
283:
284: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
285: 'K_TABLE_CLAUSE', tspace_tbl_param);
286:
287: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
288: 'R_TABLE_CLAUSE', tspace_tbl_param || ' LOB (data) STORE AS (CACHE)');

Line 287: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

283:
284: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
285: 'K_TABLE_CLAUSE', tspace_tbl_param);
286:
287: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
288: 'R_TABLE_CLAUSE', tspace_tbl_param || ' LOB (data) STORE AS (CACHE)');
289:
290: -- Caching the "data" LOB column is the default (at later versions of Oracle Text).
291: -- For index specific STORAGE preference, setting the clause "lob (data) (cache reads)"

Line 295: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

291: -- For index specific STORAGE preference, setting the clause "lob (data) (cache reads)"
292: -- should be ensured (the "lob .. store as" clause is only for newly added LOB columns).
293: --alter table dr$prd_ctx_index$r modify lob (data) (cache reads);
294:
295: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
296: 'N_TABLE_CLAUSE', tspace_tbl_param);
297:
298: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
299: 'P_TABLE_CLAUSE', tspace_tbl_param);

Line 298: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

294:
295: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
296: 'N_TABLE_CLAUSE', tspace_tbl_param);
297:
298: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
299: 'P_TABLE_CLAUSE', tspace_tbl_param);
300:
301: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
302: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');

Line 301: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

297:
298: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
299: 'P_TABLE_CLAUSE', tspace_tbl_param);
300:
301: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
302: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');
303:
304: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
305: -- 'I_ROWID_INDEX_CLAUSE', tspace_idx_param);

Line 304: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',

300:
301: ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
302: 'I_INDEX_CLAUSE', tspace_idx_param || ' COMPRESS 2');
303:
304: --ad_ctx_ddl.set_attribute (g_Pref_Owner || '.DOM_DOC_STORAGE',
305: -- 'I_ROWID_INDEX_CLAUSE', tspace_idx_param);
306:
307: --------------------------------
308: -- Create DATASTORE preference

Line 313: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'USER_DATASTORE');

309: --------------------------------
310:
311: Log_Line (l_api_name || ': creating DATASTORE preference ...');
312:
313: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'USER_DATASTORE');
314:
315:
316: /* Commented by Gopi as CLOB output is not required for DOM module*/
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'CLOB');

Line 317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'CLOB');

313: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'USER_DATASTORE');
314:
315:
316: /* Commented by Gopi as CLOB output is not required for DOM module*/
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Dom_Text_CLOB"');
319:
320: /* Unommented by Gopi as varchar output is required for DOM module*/
321: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');

Line 318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Dom_Text_CLOB"');

314:
315:
316: /* Commented by Gopi as CLOB output is not required for DOM module*/
317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Dom_Text_CLOB"');
319:
320: /* Unommented by Gopi as varchar output is required for DOM module*/
321: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
322: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Doc_Text_VARCHAR2"');

Line 321: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');

317: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'CLOB');
318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Dom_Text_CLOB"');
319:
320: /* Unommented by Gopi as varchar output is required for DOM module*/
321: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
322: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Doc_Text_VARCHAR2"');
323: ------------------------------------
324: -- Create SECTION GROUP preference
325: ------------------------------------

Line 322: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Doc_Text_VARCHAR2"');

318: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Dom_Text_CLOB"');
319:
320: /* Unommented by Gopi as varchar output is required for DOM module*/
321: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'OUTPUT_TYPE', 'VARCHAR2');
322: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_DATASTORE', 'PROCEDURE', '"DOM_DOC_TEXT_CTX_PKG"."Get_Doc_Text_VARCHAR2"');
323: ------------------------------------
324: -- Create SECTION GROUP preference
325: ------------------------------------
326:

Line 329: --ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.DOM_DOC_STOPLIST', 'AUTO_SECTION_GROUP');

325: ------------------------------------
326:
327: --Log_Line (l_api_name || ': creating SECTION_GROUP preference ...');
328:
329: --ad_ctx_ddl.Create_Section_Group (g_Pref_Owner || '.DOM_DOC_STOPLIST', 'AUTO_SECTION_GROUP');
330:
331: -------------------------------
332: -- Create STOPLIST preference
333: -------------------------------

Line 338: ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.DOM_DOC_STOPLIST');

334:
335: Log_Line (l_api_name || ': creating STOPLIST preference ...');
336:
337: -- This should create stoplist equivalent to CTXSYS.EMPTY_STOPLIST
338: ad_ctx_ddl.Create_Stoplist (g_Pref_Owner || '.DOM_DOC_STOPLIST');
339:
340: -------------------------------
341: -- Create WORDLIST preference
342: -------------------------------

Line 346: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'BASIC_WORDLIST');

342: -------------------------------
343:
344: Log_Line (l_api_name || ': creating WORDLIST preference ...');
345:
346: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'BASIC_WORDLIST');
347:
348: -- Enable prefix indexing to improve performance for wildcard searches
349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);

Line 349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');

345:
346: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'BASIC_WORDLIST');
347:
348: -- Enable prefix indexing to improve performance for wildcard searches
349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);

Line 350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);

346: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'BASIC_WORDLIST');
347:
348: -- Enable prefix indexing to improve performance for wildcard searches
349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);

Line 351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);

347:
348: -- Enable prefix indexing to improve performance for wildcard searches
349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
355:

Line 352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);

348: -- Enable prefix indexing to improve performance for wildcard searches
349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
355:
356: -- This option should be TRUE only when left-truncated wildcard searching is expected

Line 353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);

349: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_INDEX', 'TRUE');
350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
355:
356: -- This option should be TRUE only when left-truncated wildcard searching is expected
357: -- to be frequent and needs to be fast (at the cost of increased index time and space).

Line 354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);

350: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MIN_LENGTH', 2);
351: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MIN', 2);
352: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_MAX_LENGTH', 32);
353: --ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'PREFIX_LENGTH_MAX', 32);
354: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'WILDCARD_MAXTERMS', 5000);
355:
356: -- This option should be TRUE only when left-truncated wildcard searching is expected
357: -- to be frequent and needs to be fast (at the cost of increased index time and space).
358: --

Line 359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');

355:
356: -- This option should be TRUE only when left-truncated wildcard searching is expected
357: -- to be frequent and needs to be fast (at the cost of increased index time and space).
358: --
359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');
360:
361: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
362: -- Use automatic language detection for stemming and fuzzy matching
363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');

Line 363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');

359: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'SUBSTRING_INDEX', 'FALSE');
360:
361: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
362: -- Use automatic language detection for stemming and fuzzy matching
363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_MATCH', 'AUTO');
365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_SCORE', 40);
366: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_NUMRESULTS', 120);
367:

Line 364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_MATCH', 'AUTO');

360:
361: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
362: -- Use automatic language detection for stemming and fuzzy matching
363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_MATCH', 'AUTO');
365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_SCORE', 40);
366: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_NUMRESULTS', 120);
367:
368: -----------------------------------------------

Line 365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_SCORE', 40);

361: -- WORDLIST attribute defaults: STEMMER: 'ENGLISH'; FUZZY_MATCH: 'GENERIC'
362: -- Use automatic language detection for stemming and fuzzy matching
363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_MATCH', 'AUTO');
365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_SCORE', 40);
366: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_NUMRESULTS', 120);
367:
368: -----------------------------------------------
369: -- Create language-specific LEXER preferences

Line 366: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_NUMRESULTS', 120);

362: -- Use automatic language detection for stemming and fuzzy matching
363: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'STEMMER', 'AUTO');
364: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_MATCH', 'AUTO');
365: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_SCORE', 40);
366: ad_ctx_ddl.Set_Attribute (g_Pref_Owner || '.DOM_DOC_WORDLIST', 'FUZZY_NUMRESULTS', 120);
367:
368: -----------------------------------------------
369: -- Create language-specific LEXER preferences
370: -----------------------------------------------

Line 382: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');

378: IF ( Lang_Code_List(i) = 'JA' ) THEN
379:
380: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
381: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
382: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
383: ELSE
384: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
385: END IF;
386:

Line 384: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');

380: -- Use JAPANESE_LEXER if db charset is UTF8, JA16SJIS, or JA16EUC.
381: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
382: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_LEXER');
383: ELSE
384: ad_ctx_ddl.Create_Preference (Lexer_Name, 'JAPANESE_VGRAM_LEXER');
385: END IF;
386:
387: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
388:

Line 391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');

387: ELSIF ( Lang_Code_List(i) = 'KO' ) THEN
388:
389: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
390: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');

Line 392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');

388:
389: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
390: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

Line 393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');

389: -- Use KOREAN_MORPH_LEXER if db charset is UTF8 or KO16KSC5601.
390: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');

Line 394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

390: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.0 ) THEN
391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');

Line 395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');

391: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_MORPH_LEXER');
392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');

Line 396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

392: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB_ADJECTIVE', 'TRUE');
393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');

Line 397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');

393: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONE_CHAR_WORD', 'TRUE');
394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');

Line 398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');

394: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE

Line 399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');

395: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'NGRAM');
396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE
403:

Line 400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');

396: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE
403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');

Line 401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');

397: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'HANJA', 'FALSE');
398: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'LONG_WORD', 'TRUE');
399: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'JAPANESE', 'FALSE');
400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE
403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');

Line 404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');

400: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ENGLISH', 'TRUE');
401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE
403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');

Line 405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');

401: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TO_UPPER', 'TRUE');
402: ELSE
403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

Line 406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');

402: ELSE
403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');

Line 407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');

403:
404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

Line 408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');

404: ad_ctx_ddl.Create_Preference (Lexer_Name, 'KOREAN_LEXER');
405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');

Line 409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');

405: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'VERB', 'TRUE');
406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');

Line 410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');

406: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADJECTIVE', 'TRUE');
407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
414: END IF;

Line 411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');

407: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ADVERB', 'TRUE');
408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
414: END IF;
415:

Line 412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');

408: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ONECHAR', 'TRUE');
409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
414: END IF;
415:
416: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN

Line 413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');

409: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMBER', 'TRUE');
410: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'TRUE');
411: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MORPHEME', 'TRUE');
412: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOHANGEUL', 'TRUE');
413: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'TOUPPER', 'TRUE');
414: END IF;
415:
416: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
417:

Line 419: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');

415:
416: ELSIF ( Lang_Code_List(i) IN ('ZHS', 'ZHT') ) THEN
417:
418: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
419: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
420: ELSE
421: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
422: END IF;
423:

Line 421: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');

417:
418: IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
419: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_LEXER');
420: ELSE
421: ad_ctx_ddl.Create_Preference (Lexer_Name, 'CHINESE_VGRAM_LEXER');
422: END IF;
423:
424: ELSE
425: -- All other languages use basic lexer.

Line 427: ad_ctx_ddl.Create_Preference (Lexer_Name, 'BASIC_LEXER');

423:
424: ELSE
425: -- All other languages use basic lexer.
426:
427: ad_ctx_ddl.Create_Preference (Lexer_Name, 'BASIC_LEXER');
428:
429: -- The following language-independent attributes are
430: -- common to the BASIC_LEXER preference object.
431:

Line 432: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');

428:
429: -- The following language-independent attributes are
430: -- common to the BASIC_LEXER preference object.
431:
432: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
433: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
434:
435: -- For printjoin characters include all possible flex segment separators
436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');

Line 433: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');

429: -- The following language-independent attributes are
430: -- common to the BASIC_LEXER preference object.
431:
432: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
433: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
434:
435: -- For printjoin characters include all possible flex segment separators
436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
437: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');

Line 436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');

432: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_TEXT', 'YES');
433: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
434:
435: -- For printjoin characters include all possible flex segment separators
436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
437: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
439:
440: -- The default values for numjoin and numgroup are determined by

Line 437: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');

433: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_THEMES', 'NO');
434:
435: -- For printjoin characters include all possible flex segment separators
436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
437: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
439:
440: -- The default values for numjoin and numgroup are determined by
441: -- the NLS initialization parameters that are specified for the database.

Line 438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');

434:
435: -- For printjoin characters include all possible flex segment separators
436: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PRINTJOINS', '-_*~^+.$#@:|&');
437: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'CONTINUATION', '-\');
438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
439:
440: -- The default values for numjoin and numgroup are determined by
441: -- the NLS initialization parameters that are specified for the database.
442: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');

Line 442: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');

438: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'PUNCTUATIONS', '.?!');
439:
440: -- The default values for numjoin and numgroup are determined by
441: -- the NLS initialization parameters that are specified for the database.
442: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');
443: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');
444:
445: -- Stem indexing stems tokens at indexing time to a single base form in addition
446: -- to the normal forms. This enables better query performance for stem ($) queries.

Line 443: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');

439:
440: -- The default values for numjoin and numgroup are determined by
441: -- the NLS initialization parameters that are specified for the database.
442: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMGROUP', ',');
443: --ad_ctx_ddl.Set_Attribute (Lexer_Name, 'NUMJOIN', '.');
444:
445: -- Stem indexing stems tokens at indexing time to a single base form in addition
446: -- to the normal forms. This enables better query performance for stem ($) queries.
447:

Line 453: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');

449: -- This would not affect stem expansion (with $) at query time.
450: --
451: --IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
452: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
453: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
454: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
455: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
456: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');

Line 455: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');

451: --IF ( DOM_DOC_TEXT_UTIL.get_DB_Version_Num >= 9.2 ) THEN
452: -- IF ( Lang_Code_List(i) IN ('US', 'GB') ) THEN
453: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
454: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
455: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
456: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
458: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');

Line 457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');

453: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ENGLISH');
454: -- ELSIF ( Lang_Code_List(i) = 'NL' ) THEN
455: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
456: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
458: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
460: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
461: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');

Line 459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');

455: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'DUTCH');
456: -- ELSIF ( Lang_Code_List(i) = 'D' ) THEN
457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
458: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
460: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
461: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
462: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
463: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');

Line 461: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');

457: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'GERMAN');
458: -- ELSIF ( Lang_Code_List(i) = 'F' ) THEN
459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
460: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
461: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
462: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
463: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');
464: -- END IF;
465: --END IF;

Line 463: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');

459: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'FRENCH');
460: -- ELSIF ( Lang_Code_List(i) = 'I' ) THEN
461: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'ITALIAN');
462: -- ELSIF ( Lang_Code_List(i) IN ('E', 'ESA') ) THEN
463: -- ad_ctx_ddl.Set_Attribute (Lexer_Name, 'INDEX_STEMS', 'SPANISH');
464: -- END IF;
465: --END IF;
466:
467: -- Language-specific attribute values for BASIC_LEXER preference object

Line 470: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');

466:
467: -- Language-specific attribute values for BASIC_LEXER preference object
468:
469: IF ( Lang_Code_List(i) = 'NL' ) THEN
470: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');
471:
472: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
473: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
474: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.

Line 473: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');

469: IF ( Lang_Code_List(i) = 'NL' ) THEN
470: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'DUTCH');
471:
472: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
473: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
474: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
475: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
476: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
477:

Line 475: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');

471:
472: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
473: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
474: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
475: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
476: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
477:
478: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

Line 476: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');

472: ELSIF ( Lang_Code_List(i) = 'D' ) THEN
473: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'COMPOSITE', 'GERMAN');
474: -- Basic lexer in 8.1.7 allows the MIXED_CASE to be FALSE when COMPOSITE is set.
475: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
476: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
477:
478: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
480:

Line 479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

475: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'MIXED_CASE', 'NO');
476: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'GERMAN');
477:
478: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
480:
481: ELSIF ( Lang_Code_List(i) = 'S' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');
483:

Line 482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');

478: ELSIF ( Lang_Code_List(i) = 'DK' ) THEN
479: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
480:
481: ELSIF ( Lang_Code_List(i) = 'S' ) THEN
482: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'SWEDISH');
483:
484: ELSIF ( Lang_Code_List(i) = 'N' ) THEN
485: -- Both Norwegian and Danish use the same special characters that are
486: -- rendered alternatively as "aa", "ae", and "oe".

Line 487: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');

483:
484: ELSIF ( Lang_Code_List(i) = 'N' ) THEN
485: -- Both Norwegian and Danish use the same special characters that are
486: -- rendered alternatively as "aa", "ae", and "oe".
487: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
488:
489: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
490: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
491:

Line 490: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');

486: -- rendered alternatively as "aa", "ae", and "oe".
487: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'DANISH');
488:
489: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
490: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
491:
492: ELSE
493: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');
494:

Line 493: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');

489: ELSIF ( Lang_Code_List(i) = 'F' ) THEN
490: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'BASE_LETTER', 'YES');
491:
492: ELSE
493: ad_ctx_ddl.Set_Attribute (Lexer_Name, 'ALTERNATE_SPELLING', 'NONE');
494:
495: END IF;
496: END IF;
497:

Line 506: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_MULTI_LEXER', 'MULTI_LEXER');

502: ----------------------------------
503:
504: Log_Line (l_api_name || ': creating MULTI_LEXER preference ...');
505:
506: ad_ctx_ddl.Create_Preference (g_Pref_Owner || '.DOM_DOC_MULTI_LEXER', 'MULTI_LEXER');
507:
508: FOR i IN Lang_Code_List.FIRST .. Lang_Code_List.LAST
509: LOOP
510: Lexer_Name := g_Pref_Owner || '.DOM_DOC_LEXER_' || Lang_Code_List(i);

Line 519: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.DOM_DOC_MULTI_LEXER', 'DEFAULT'

515: -- when adding the sub lexers:
516:
517: IF ( Lang_Code_List(i) = 'US' ) THEN
518: -- US English lexer to handle everything else.
519: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.DOM_DOC_MULTI_LEXER', 'DEFAULT'
520: , g_Pref_Owner || '.DOM_DOC_LEXER_US' );
521: ELSE
522: ad_ctx_ddl.Add_Sub_Lexer
523: ( lexer_name => g_Pref_Owner || '.DOM_DOC_MULTI_LEXER'

Line 522: ad_ctx_ddl.Add_Sub_Lexer

518: -- US English lexer to handle everything else.
519: ad_ctx_ddl.Add_Sub_Lexer ( g_Pref_Owner || '.DOM_DOC_MULTI_LEXER', 'DEFAULT'
520: , g_Pref_Owner || '.DOM_DOC_LEXER_US' );
521: ELSE
522: ad_ctx_ddl.Add_Sub_Lexer
523: ( lexer_name => g_Pref_Owner || '.DOM_DOC_MULTI_LEXER'
524: , language => Lang_Code_List(i)
525: , sub_lexer => Lexer_Name
526: --, alt_value => Lang_ISO_List(i)