Oracle CTX_MATCHES
Version 26ai

General Information
Library Note Morgan's Library Page Header
The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?
Purpose Orphaned package header supporting the MATCH_SCORE operator
AUTHID CURRENT_USER
Dependencies
DR$LIB ODCIINDEXCTX RULEINDEXMETHODS
MATCHES    
Documented Yes
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/dr0itypr.sql
 
MATCHES
Undocumented

Overload 1
ctx_matches.matches(
colval IN     VARCHAR2,
text   IN     VARCHAR2,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
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
Overload 2 ctx_matches.matches(
colval IN     CLOB,
text   IN     VARCHAR2,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
LIBRARY dr$lib
WITH CONTEXT PARAMTERS(
context,
colval,
colval INDICATOR,
text,
text INDICATOR,
text LENGTH,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 3 ctx_matches.matches(
colval IN     BLOB,
text   IN     VARCHAR2,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
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
Overload 4 ctx_matches.matches(
colval IN     VARCHAR2,
text   IN     CLOB,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
LIBRARY dr$lib
WITH CONTEXT PARAMETERS(
context,
colval,
colval INDICATOR,
text,
text INDICATOR,
text CHARSETID,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 5 ctx_matches.matches(
colval IN     CLOB,
text   IN     CLOB,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
LIBRARY dr$lib
WITH CONTEXT PARAMETERS(
context,
colval,
colval INDICATOR,
text,
text INDICATOR,
text CHARSETID,
ia,
ia INDICATOR STRUCT,
sctx,
sctx INDICATOR STRUCT,
cflg,
cflg INDICATOR,
RETURN OCINumber);
TBD
Overload 6 ctx_matches.matches(
colval IN     BLOB,
text   IN     CLOB,
ia     IN     sys.odciindexctx,
sctx   IN OUT RuleIndexMethods,
cflg   IN     NUMBER)
RETURN NUMBER PARALLEL_ENABLE IS LANGUAGE C
name "rulematches"
LIBRARY dr$lib
WITH CONTEXT PARAMETERS(
context,
colval,
colval INDICATOR,
text,
text INDICATOR,
text CHARSETID,
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_CONTAINS
CTX_DDL
CTX_DOC
CTX_ENTITY
CTX_OUTPUT
CTX_QUERY
CTX_REPORT
CTX_THES
CTX_TREE
CTX_ULEXER
CTX_XPCONTAINS
DBMS_SEARCH
What's New In 21c
What's New In 26ai

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