ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
EIX framework interfaces
AUTHID
CURRENT_USER
Dependencies
CONTAINS
ODCIINDEXCTX
URITYPE
DR$LIB
TEXTINDEXMETHODS
XMLTYPE
Documented
No
First Available
Not known
Pragma
PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
Security Model
Owned by SYS with no privileges granted
Source
{ORACLE_HOME}/ctx/admin/dr0itype.sql
TEXTCONTAINS
VARCHAR2 column type, VARCHAR2 query string type
Overload 1
ctx_contains.textContains(
colval IN VARCHAR2,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia,
ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
VARCHAR2 column type, CLOB query string type
Overload 2
ctx_contains.textContains(
colval IN VARCHAR2,
Text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
CLOB column type, VARCHAR2 query string type
Overload 3
ctx_contains.textContains(
colval IN CLOB,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv */)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia,
ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
CLOB column type, CLOB query string type
Overload 4
ctx_contains.textContains(
colval IN CLOB,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv */)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
BLOB column type, VARCHAR2 query string type
Overload 5
ctx_contains.textContains(
Colval IN BLOB,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
BLOB column type, CLOB query string type
Overload 6
ctx_contains.textContains(
colval IN BLOB,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
BFILE column type, VARCHAR2 query string type
Overload 7
ctx_contains.textContains(
colval IN BFILE,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv */)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
BFILE column type, CLOB query string type
Overload 8
ctx_contains.textContains(
colval IN BFILE,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv */)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
XMLTYPE column type, VARCHAR2 query string type
Overload 9
ctx_contains.textContains(
colval IN sys.xmltype,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia,
ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
XMLTYPE column type, CLOB query string type
Overload 10
ctx_contains.textContains(
colval IN sys.xmltype,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
URITYPE column type, VARCHAR2 query string type
Overload 11
ctx_contains.textContains(
colval IN sys.uritype,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR STRUCT, Text, Text INDICATOR, Text LENGTH,
ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
URITYPE column type, CLOB query string type
Overload 12
ctx_contains.textContains(
colval IN sys.uritype,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg number /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR STRUCT, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
JSON column type, VARCHAR2 query string type
Overload 13
ctx_contains.textContains(
cColval IN JSON,
text IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, Text LENGTH, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);
TBD
JSON column type, CLOB query string type
Overload 14
ctx_contains.textContains(
colval IN JSON,
text IN CLOB,
ia IN sys.odciindexctx,
sctx IN OUT TextIndexMethods,
cflg IN NUMBER /*, env sys.ODCIEnv*/)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "contains_clob"
library dr$lib
with context
parameters(context, Colval, Colval INDICATOR, Text, Text INDICATOR, ia, ia INDICATOR STRUCT, sctx, sctx INDICATOR STRUCT, cflg, cflg INDICATOR, RETURN OCINumber);