1 package drispl as
2
3 /*-------------------- create_stoplist --------------------------*/
4
5 PROCEDURE create_stoplist(
6 stoplist_name in varchar2,
7 stoplist_type in varchar2 default 'BASIC_STOPLIST',
8 preference_implicit_commit in boolean
9 );
10
11 /*-------------------- drop_stoplist --------------------------*/
12
13 PROCEDURE drop_stoplist(
14 stoplist_name in varchar2,
15 preference_implicit_commit in boolean
16 );
17
18 /*-------------------- drop_user_stoplists ---------------------*/
19
20 PROCEDURE drop_user_stoplists(
21 user_name in varchar2 := null
22 );
23
24 /*-------------------- add_stopobj --------------------------*/
25
26 PROCEDURE add_stopobj(
27 stoplist_name in varchar2,
28 obj_type in varchar2,
29 stopword in varchar2,
30 stoppattern in varchar2 default NULL,
31 language in varchar2 default NULL,
32 language_dependent in boolean default TRUE,
33 preference_implicit_commit in boolean
34 );
35
36 /*-------------------- remove_stopobj --------------------------*/
37
38 PROCEDURE remove_stopobj(
39 stoplist_name in varchar2,
40 obj_type in varchar2,
41 stopword in varchar2,
42 language in varchar2 default NULL
43 );
44
45 /*------------------------ copy_stoplist -----------------------------------*/
46
47 function copy_stoplist(
48 p_idx_id in number,
49 p_stoplist in varchar2,
50 p_section_id in number,
51 p_rcount out number
52 )
53 return dr_def.pref_rec;
54
55 /*----------------------- IndexAddStopword -------------------------*/
56 /* add a stopword to an already-existing index */
57
58 PROCEDURE IndexAddStopword(
59 ia in sys.ODCIIndexInfo,
60 idx in dr_def.idx_rec,
61 stopword in varchar2,
62 language in varchar2,
63 language_dependent in boolean default TRUE,
64 sectionid in number,
65 add_ML_tokens out boolean
66 );
67
68 /*----------------------- IndexRemStopword -------------------------*/
69 /* remove a stopword from an already-existing index */
70
71 PROCEDURE IndexRemStopword(
72 ia in sys.ODCIIndexInfo,
73 idx in dr_def.idx_rec,
74 stopword in varchar2,
75 language in varchar2,
76 for_all in boolean default FALSE,
77 rem_ML_tokens out boolean
78 );
79
80 /*----------------------- GetIndexStopwords -------------------------*/
81 /* get stopwords from already-existing index */
82
83 PROCEDURE GetIndexStopwords(
84 p_idx_id in number,
85 p_obj_id in binary_integer,
86 o_spw in out nocopy dr_def.spw_tab
87 );
88
89 /*---------------------- MigrateToMultiStoplist ---------------------*/
90 /* Migrate from basic stoplist to multi stoplist */
91
92 PROCEDURE MigrateToMultiStoplist(
93 ia in sys.ODCIIndexInfo,
94 idx in dr_def.idx_rec,
95 langcol in varchar2
96 );
97
98 PROCEDURE GetSPLLang(
99 idx in dr_def.idx_rec,
100 language in varchar2,
101 language_dependent in boolean,
102 out_lang in out varchar2
103 );
104
105 end drispl;