1 package ctx_contains authid current_user as
2 -- varchar2 column type, varchar2 query string type
3 function Textcontains(Colval in varchar2,
4 Text in varchar2, ia sys.odciindexctx,
5 sctx IN OUT TextIndexMethods,
6 cflg number /*, env sys.ODCIEnv*/)
7 return number parallel_enable is language C
8 name "contains"
9 library dr$lib
10 with context
11 parameters(
12 context,
13 Colval,
14 Colval INDICATOR,
15 Text,
16 Text INDICATOR,
17 Text LENGTH,
18 ia,
19 ia INDICATOR STRUCT,
20 sctx,
21 sctx INDICATOR STRUCT,
22 cflg,
23 cflg INDICATOR,
24 return OCINumber
25 );
26 -- varchar2 column type, clob query string type
27 function Textcontains(Colval in varchar2,
28 Text in clob, ia sys.odciindexctx,
29 sctx IN OUT TextIndexMethods,
30 cflg number /*, env sys.ODCIEnv*/)
31 return number parallel_enable is language C
32 name "contains_clob"
33 library dr$lib
34 with context
35 parameters(
36 context,
37 Colval,
38 Colval INDICATOR,
39 Text,
40 Text INDICATOR,
41 ia,
42 ia INDICATOR STRUCT,
43 sctx,
44 sctx INDICATOR STRUCT,
45 cflg,
46 cflg INDICATOR,
47 return OCINumber
48 );
49 -- clob column type, varchar2 query string type
50 function Textcontains(Colval in clob,
51 Text in varchar2, ia sys.odciindexctx,
52 sctx IN OUT TextIndexMethods,
53 cflg number /*, env sys.ODCIEnv */)
54 return number parallel_enable is language C
55 name "contains"
56 library dr$lib
57 with context
58 parameters(
59 context,
60 Colval,
61 Colval INDICATOR,
62 Text,
63 Text INDICATOR,
64 Text LENGTH,
65 ia,
66 ia INDICATOR STRUCT,
67 sctx,
68 sctx INDICATOR STRUCT,
69 cflg,
70 cflg INDICATOR,
71 return OCINumber
72 );
73 -- clob column type, clob query string type
74 function Textcontains(Colval in clob,
75 Text in clob, ia sys.odciindexctx,
76 sctx IN OUT TextIndexMethods,
77 cflg number /*, env sys.ODCIEnv */)
78 return number parallel_enable is language C
79 name "contains_clob"
80 library dr$lib
81 with context
82 parameters(
83 context,
84 Colval,
85 Colval INDICATOR,
86 Text,
87 Text INDICATOR,
88 ia,
89 ia INDICATOR STRUCT,
90 sctx,
91 sctx INDICATOR STRUCT,
92 cflg,
93 cflg INDICATOR,
94 return OCINumber
95 );
96 -- blob column type, varchar2 query string type
97 function Textcontains(Colval in blob,
98 Text in varchar2, ia sys.odciindexctx,
99 sctx IN OUT TextIndexMethods,
100 cflg number /*, env sys.ODCIEnv*/)
101 return number parallel_enable is language C
102 name "contains"
103 library dr$lib
104 with context
105 parameters(
106 context,
107 Colval,
108 Colval INDICATOR,
109 Text,
110 Text INDICATOR,
111 Text LENGTH,
112 ia,
113 ia INDICATOR STRUCT,
114 sctx,
115 sctx INDICATOR STRUCT,
116 cflg,
117 cflg INDICATOR,
118 return OCINumber
119 );
120 -- blob column type, clob query string type
121 function Textcontains(Colval in blob,
122 Text in clob, ia sys.odciindexctx,
123 sctx IN OUT TextIndexMethods,
124 cflg number /*, env sys.ODCIEnv*/)
125 return number parallel_enable is language C
126 name "contains_clob"
127 library dr$lib
128 with context
129 parameters(
130 context,
131 Colval,
132 Colval INDICATOR,
133 Text,
134 Text INDICATOR,
135 ia,
136 ia INDICATOR STRUCT,
137 sctx,
138 sctx INDICATOR STRUCT,
139 cflg,
140 cflg INDICATOR,
141 return OCINumber
142 );
143 -- bfile column type, varchar2 query string type
144 function Textcontains(Colval in bfile,
145 Text in varchar2, ia sys.odciindexctx,
146 sctx IN OUT TextIndexMethods,
147 cflg number /*, env sys.ODCIEnv */)
148 return number parallel_enable is language C
149 name "contains"
150 library dr$lib
151 with context
152 parameters(
153 context,
154 Colval,
155 Colval INDICATOR,
156 Text,
157 Text INDICATOR,
158 Text LENGTH,
159 ia,
160 ia INDICATOR STRUCT,
161 sctx,
162 sctx INDICATOR STRUCT,
163 cflg,
164 cflg INDICATOR,
165 return OCINumber
166 );
167 -- bfile column type, clob query string type
168 function Textcontains(Colval in bfile,
169 Text in clob, ia sys.odciindexctx,
170 sctx IN OUT TextIndexMethods,
171 cflg number /*, env sys.ODCIEnv */)
172 return number parallel_enable is language C
173 name "contains_clob"
174 library dr$lib
175 with context
176 parameters(
177 context,
178 Colval,
179 Colval INDICATOR,
180 Text,
181 Text INDICATOR,
182 ia,
183 ia INDICATOR STRUCT,
184 sctx,
185 sctx INDICATOR STRUCT,
186 cflg,
187 cflg INDICATOR,
188 return OCINumber
189 );
190 -- Xmltype column type, varchar2 query string type
191 function Textcontains(Colval in sys.xmltype,
192 Text in varchar2, ia sys.odciindexctx,
193 sctx IN OUT TextIndexMethods,
194 cflg number /*, env sys.ODCIEnv*/)
195 return number parallel_enable is language C
196 name "contains"
197 library dr$lib
198 with context
199 parameters(
200 context,
201 Colval,
202 Colval INDICATOR,
203 Text,
204 Text INDICATOR,
205 Text LENGTH,
206 ia,
207 ia INDICATOR STRUCT,
208 sctx,
209 sctx INDICATOR STRUCT,
210 cflg,
211 cflg INDICATOR,
212 return OCINumber
213 );
214 -- Xmltype column type, clob query string type
215 function Textcontains(Colval in sys.xmltype,
216 Text in clob, ia sys.odciindexctx,
217 sctx IN OUT TextIndexMethods,
218 cflg number /*, env sys.ODCIEnv*/)
219 return number parallel_enable is language C
220 name "contains_clob"
221 library dr$lib
222 with context
223 parameters(
224 context,
225 Colval,
226 Colval INDICATOR,
227 Text,
228 Text INDICATOR,
229 ia,
230 ia INDICATOR STRUCT,
231 sctx,
232 sctx INDICATOR STRUCT,
233 cflg,
234 cflg INDICATOR,
235 return OCINumber
236 );
237 -- Uritype column type, varchar2 query string type
238 function Textcontains(Colval in sys.uritype,
239 Text in varchar2, ia sys.odciindexctx,
240 sctx IN OUT TextIndexMethods,
241 cflg number /*, env sys.ODCIEnv*/)
242 return number parallel_enable is language C
243 name "contains"
244 library dr$lib
245 with context
246 parameters(
247 context,
248 Colval,
249 Colval INDICATOR STRUCT,
250 Text,
251 Text INDICATOR,
252 Text LENGTH,
253 ia,
254 ia INDICATOR STRUCT,
255 sctx,
256 sctx INDICATOR STRUCT,
257 cflg,
258 cflg INDICATOR,
259 return OCINumber
260 );
261 -- Uritype column type, clob query string type
262 function Textcontains(Colval in sys.uritype,
263 Text in clob, ia sys.odciindexctx,
264 sctx IN OUT TextIndexMethods,
265 cflg number /*, env sys.ODCIEnv*/)
266 return number parallel_enable is language C
267 name "contains_clob"
268 library dr$lib
269 with context
270 parameters(
271 context,
272 Colval,
273 Colval INDICATOR STRUCT,
274 Text,
275 Text INDICATOR,
276 ia,
277 ia INDICATOR STRUCT,
278 sctx,
279 sctx INDICATOR STRUCT,
280 cflg,
281 cflg INDICATOR,
282 return OCINumber
283 );
284
285 end ctx_contains;