About PL/SQL Packages to Generate Embeddings

Choose to implement Vector Utility PL/SQL packages to perform chunking, embedding, and text generation operations along with text processing and similarity search, both within and outside the database. The supplied PL/SQL packages for vector generation are DBMS_VECTOR and DBMS_VECTOR_CHAIN.

These packages can work with both "vector embedding models in ONNX format" (that you load into the database) and "third-party vector embedding models" (by calling third-party REST APIs). These also let you create, run, and schedule end-to-end data transformation and search pipelines.

Each package is made up of subprograms, such as chainable utility functions and vector helper procedures.

• About Chainable Utility Functions and Common Use Cases
  These are intended to be a set of chainable and flexible "stages" through which you pass your input data to transform into a different representation, including vectors.
• About Vector Helper Procedures
  Vector helper procedures let you configure authentication credentials and language-specific data, for use in chainable utility functions.
• Supplied Vector Utility PL/SQL Packages
  Use either a lightweight DBMS_VECTOR package or a more advanced DBMS_VECTOR_CHAIN package with full capabilities.
• Supported Third-Party Provider Operations
  Review a list of third-party REST providers that are supported with Vector Utility PL/SQL packages and the corresponding operations allowed for each of those.
• Terms of Using Vector Utility PL/SQL Packages
  You must understand the terms of using REST APIs that are part of Vector Utility PL/SQL packages.
• Validate JSON Input Parameters
  You can optionally validate the structure of your JSON input to the DBMS_VECTOR.UTL and DBMS_VECTOR_CHAIN.UTL functions, which use JSON to define their input parameters.