Oracle CTX_CONTAINS
Version 21c

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

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

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-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx