Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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);