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 will be available on generic Linux platforms in January and soon on AIX and Windows

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