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
Undocumented
AUTHID
CURRENT_USER
Dependencies
CATINDEXMETHODS
DR$LIB
ODCIINDEXCTX
CATSEARCH
Documented
No
First Available
20c
Pragmas
PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);
Security Model
Owned by CTXSYS with EXECUTE granted to PUBLIC
Source
{ORACLE_HOME}/rdbms/admin/dr0itypc.sql
CATSEARCH (new 21c)
Undocumented
Overload 1
ctx_catsearch.catsearch(
colval IN VARCHAR2,
text IN VARCHAR2,
condcls IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT ctxsys.catindexmethods,
cflg IN NUMBER)
RETURN NUMBER parallel_enable is language C
NAME "catsearch"
LIBRARY dr$lib
WITH context
parameters(
context,
Colval,
Colval INDICATOR,
Text,
Text INDICATOR,
Text LENGTH,
condcls,
condcls INDICATOR,
condcls LENGTH,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 2
ctx_catsearch.catsearch(
colval IN VARCHAR2,
text IN CLOB,
condcls IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT ctxsys.catindexmethods,
cflg IN NUMBER)
RETURN NUMBER parallel_enable is language C
NAME "catsearch"
LIBRARY dr$lib
WITH context
parameters(
context,
Colval,
Colval INDICATOR,
Text,
Text INDICATOR,
Text LENGTH,
condcls,
condcls INDICATOR,
condcls LENGTH,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 3
ctx_catsearch.catsearch(
colval IN CLOB,
text IN VARCHAR2,
condcls IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT ctxsys.catindexmethods,
cflg IN NUMBER)
RETURN NUMBER parallel_enable is language C
NAME "catsearch"
LIBRARY dr$lib
WITH context
parameters(
context,
Colval,
Colval INDICATOR,
Text,
Text INDICATOR,
Text LENGTH,
condcls,
condcls INDICATOR,
condcls LENGTH,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 4
ctx_catsearch.catsearch(
colval IN CLOB,
text IN CLOB,
condcls IN VARCHAR2,
ia IN sys.odciindexctx,
sctx IN OUT ctxsys.catindexmethods,
cflg IN NUMBER)
RETURN NUMBER parallel_enable is language C
NAME "catsearch"
LIBRARY dr$lib
WITH context
parameters(
context,
Colval,
Colval INDICATOR,
Text,
Text INDICATOR,
Text LENGTH,
condcls,
condcls INDICATOR,
condcls LENGTH,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);