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
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
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
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
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
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
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
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
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
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
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
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