19 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.
• DBMS_CLOUD_AI Package
  The following table lists the attributes and vector index parameters available in DBMS_CLOUD_AI subprograms.

19.1 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.

19.2 DBMS_CLOUD_AI Package

The following table lists the attributes and vector index parameters 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.