1 package ad_ctx_ddl AUTHID CURRENT_USER as
2 /* $Header: adctxpkg.sql 120.2 2005/08/04 03:59:42 appldev ship $ */
3 OPTLEVEL_FAST constant varchar2(4) := 'FAST';
4 OPTLEVEL_FULL constant varchar2(4) := 'FULL';
5 MAXTIME_UNLIMITED constant number := 2147483647;
6 DR_SEC_TYPE_UNKNOWN constant number := 0;
7 DR_SEC_TYPE_ZONE constant number := 1;
8 DR_SEC_TYPE_FIELD constant number := 2;
9 DR_SEC_TYPE_SPECIAL constant number := 3;
10 DR_SEC_TYPE_STOP constant number := 4;
11 DR_SEC_TYPE_ATTR constant number := 5;
12 DR_SEC_ZONE_FID constant number := 1;
13 DR_SEC_FIELD_MIN_FID constant number := 16;
14 DR_SEC_FIELD_MAX_FID constant number := 79;
15 DR_SEC_MAX_FIELD constant number := 64;
16 procedure add_attr_section (group_name in varchar2,
17 section_name in varchar2,
18 tag in varchar2);
19 procedure add_field_section (group_name in varchar2,
20 section_name in varchar2,
21 tag in varchar2,
22 visible in boolean default FALSE);
23 procedure add_index (set_name in varchar2,
24 column_list in varchar2,
25 storage_clause in varchar2 default null);
26 procedure add_special_section (group_name in varchar2,
27 section_name in varchar2);
28 procedure add_stopclass (stoplist_name in varchar2,
29 stopclass in varchar2);
30 procedure add_stoptheme (stoplist_name in varchar2,
31 stoptheme in varchar2);
32 procedure add_stopword (stoplist_name in varchar2,
33 stopword in varchar2,
34 language in varchar2 default null);
35 procedure add_stop_section (group_name in varchar2,
36 tag in varchar2);
37 procedure add_sub_lexer (lexer_name in varchar2,
38 language in varchar2,
39 sub_lexer in varchar2,
40 alt_value in varchar2 default null);
41 procedure add_zone_section (group_name in varchar2,
42 section_name in varchar2,
43 tag in varchar2);
44 procedure create_index_set (set_name in varchar2);
45 procedure create_preference (preference_name in varchar2,
46 object_name in varchar2);
47 procedure create_section_group (group_name in varchar2,
48 group_type in varchar2);
49 procedure create_stoplist (stoplist_name in varchar2,
50 stoplist_type in varchar2 default 'BASIC_STOPLIST');
51 procedure drop_index_set (set_name in varchar2);
52 procedure drop_preference (preference_name in varchar2);
53 procedure drop_section_group (group_name in varchar2);
54 procedure drop_stoplist (stoplist_name in varchar2);
55 procedure optimize_index (idx_name in varchar2,
56 optlevel in varchar2,
57 maxtime in number default null,
58 token in varchar2 default null);
59 procedure remove_index (set_name in varchar2,
60 column_list in varchar2);
61 procedure remove_section (group_name in varchar2,
62 section_name in varchar2);
63 procedure remove_section (group_name in varchar2,
64 section_id in number);
65 procedure remove_stopclass (stoplist_name in varchar2,
66 stopclass in varchar2);
67 procedure remove_stoptheme (stoplist_name in varchar2,
68 stoptheme in varchar2);
69 procedure remove_stopword (stoplist_name in varchar2,
70 stopword in varchar2,
71 language in varchar2 default null);
72 procedure remove_sub_lexer (lexer_name in varchar2,
73 language in varchar2);
74 procedure set_attribute (preference_name in varchar2,
75 attribute_name in varchar2,
76 attribute_value in varchar2);
77 procedure sync_index (idx_name in varchar2 default null);
78 procedure unset_attribute (preference_name in varchar2,
79 attribute_name in varchar2);
80 procedure set_effective_schema(user_schema in varchar2);
81 end ad_ctx_ddl;