Oracle | DBMS_HYBRID

Oracle DBMS_HYBRID_VECTOR 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 Undocumented AI Vector Search

AUTHID CURRENT_USER

Data Types -- search result row type TYPE result IS RECORD ( doc_rowid VARCHAR2(18), score NUMBER, vector_score NUMBER, text_score NUMBER, vector_rank NUMBER, text_rank NUMBER, chunk_text VARCHAR2(32767), chunk_id VARCHAR2(4000), paths VARCHAR2(4000)); TYPE results IS TABLE OF result;

Dependencies

ALL_TAB_COLS	DRIUTL	JSON_ARRAY_T
CTX_DOC	DRIXMD	JSON_ELEMENT_T
DBMS_ASSERT	DRUE	JSON_KEY_LIST
DBMS_LOB	DRVDISP	JSON_OBJECT_T
DBMS_STANDARD	DRVDML	PLITBLM
DRIG	DRVMD	UTL_LMS
DRILIST	DR_DEF	UTL_RAW
DRIPREF

Documented Yes

First Available 23ai

Pragma PRAGMA SUPPLEMENTAL_LOG_DATA(default, NONE);

Security Model Owned by CTXSYS with EXECUTE granted to PUBLIC protected with an ACCESSIBLE BY clause.

Source {ORACLE_HOME}/ctx/admin/dbmshybridvector.pkh
{ORACLE_HOME}/ctx/admin/dbmshybridvector.plb

Subprograms

GET_HYBRID_SQL	SEARCH	SEARCH_PIPELINE
GET_SQL

GET_HYBRID_SQL (new 23ai)

Search returning CLOB (JSON or XML) dbms_hybrid_vector.get_hybrid_sql( query_spec IN JSON, p_text_query IN OUT VARCHAR2, p_has_vector IN OUT BOOLEAN, p_text_oper IN OUT VARCHAR2, p_combine_mode IN OUT VARCHAR2); RETURN CLOB ACCESSIBLE BY (PACKAGE ctxsys.drvdml, PACKAGE ctxsys.dbms_hybrid_vector);

TBD

GET_SQL (new 23ai)

API to return internal SQL based on parameters dbms_hybrid_vector.get_sql(query_spec IN JSON) RETURN CLOB;

TBD

SEARCH (new 23ai)

Undocumented dbms_hybrid_vector.search(query_spec IN JSON) RETURN CLOB;

TBD

SEARCH_PIPELINE (new 23ai)

Search as a pipelined table function dbms_hybrid_vector.search_pipeline(qparams IN JSON) RETURN results PIPELINED;

TBD