In Oracle 23ai, the DBMS_VECTOR_CHAIN package provides utilities for vector workflows.
UTL_TO_EMBEDDINGS (C) generates vector embeddings from text within the database, typically
using an ONNX model, supporting RAG and search applications. UTL_TO_CHUNKS (A) splits text, not
generates embeddings. UTL_TO_TEXT (B) converts documents to text, a preprocessing step.
UTL_TO_GENERATE_TEXT (D) doesn’t exist; text generation is handled by LLMs, not this package.
Oracle’s documentation identifies UTL_TO_EMBEDDINGS as the embedding creation function in
PL/SQL workflows.
Reference:Oracle Database 23ai PL/SQL Packages and Types Reference, DBMS_VECTOR_CHAIN.
