Select AI PL/SQL Package

The DBMS_CLOUD_AI package is available to support Select AI.

The following sections describe the DBMS_CLOUD_AI package and the installation requirements for DBMS_CLOUD packages used with Select AI.

Installing DBMS_CLOUD Packages

The DBMS_CLOUD family of packages is not pre-installed or configured with Oracle database. You need to manually install the DBMS_CLOUD packages and also configure users or roles to use this package.

For information on installation and configuration with Oracle Database 19c, Release 19.30 and above, see Using the DBMS_CLOUD Family of Packages.

For installing the DBMS_CLOUD packages and configuring users or roles for Oracle Database 19c, Releases prior to 19.30, see the MOS-NOTE with Doc ID 2748362.1. Note that earlier releases provide limited DBMS_CLOUD functionality only.

DBMS_CLOUD_AI Package

The following table lists the attributes available in DBMS_CLOUD_AI subprograms.

Subprogram Description
CREATE_PROFILE Procedure This procedure creates a new AI profile for translating natural language prompts to SQL statements.
Profile Attributes Provides AI profile attributes that you can configure.
CLEAR_PROFILE Procedure This procedure clears an active AI profile in the current session.
DISABLE_PROFILE Procedure This procedure disables an AI profile in the current database.
DROP_PROFILE Procedure This procedure drops an existing AI profile.
ENABLE_PROFILE Procedure This procedure enables an AI profile for use in the current database.
GENERATE Function This function enables you to use Select AI in a stateless manner with your existing profile.
GENERATE_SYNTHETIC_DATA Function This function generates synthetic data.
GET_PROFILE Function This function returns the profile name used in the current session.
SET_ATTRIBUTE Procedure This procedure sets AI profile attributes.
SET_ATTRIBUTES Procedure This procedure enables you to set one or more AI profile attributes by accepting attribute name and value pairs in JSON format.
SET_PROFILE Procedure This procedure sets the AI profile for the current database.
ENABLE_DATA_ACCESS Procedure Use this procedure to enable sending data to your LLM.
DISABLE_DATA_ACCESS Procedure Use this procedure to disable sending data to your LLM.
CREATE_CONVERSATION Procedure This procedure helps you create a conversation.
CREATE_CONVERSATION Function This function helps you create a conversation and use the conversation ID in other procedures.
CREATE_CONVERSATION Use the conversation attributes to customize your conversations.
UPDATE_CONVERSATION Procedure This procedure updates an existing conversation with user-specified parameters.
SET_CONVERSATION_ID Procedure This procedure sets conversation support in the current session.
GET_CONVERSATION_ID Function This procedure helps you get the conversation_id parameter.
CLEAR_CONVERSATION_ID Procedure This procedure helps you clear any conversation_id set in the current session.
DELETE_CONVERSATION_PROMPT Procedure This procedure deletes a particular prompt.
DROP_CONVERSATION Procedure This procedure deletes an entire conversation and its metadata.
SUMMARIZE Function This function summarizes your content based on the parameters.
SUMMARIZE Parameters Use the summarize attributes to customize summary generation.