[Home] [Help]
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"
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"