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
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);
