Oracle CTX_CONTAINS
Version 21c

General Information
Library Note Morgan's Library Page Header
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);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
CTX_ADM
CTX_ANL
CTX_CATSEARCH
CTX_CLS
CTX_DDL
CTX_ENTITY
CTX_MATCHES
CTX_OUTPUT
CTX_QUERY
CTX_REPORT
CTX_TREE
CTX_ULEXER
CTX_XPCONTAINS
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx