21 Select AI Agent PL/SQL Package

The DBMS_CLOUD_AI_AGENT package is available to support Select AI Agent.

The following sections describe the DBMS_CLOUD_AI_AGENT 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_AGENT Package
  The following table lists the attributes and vector index parameters available in DBMS_CLOUD_AI_AGENT subprograms.

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

21.2 DBMS_CLOUD_AI_AGENT Package

The following table lists the attributes and vector index parameters available in DBMS_CLOUD_AI_AGENT subprograms.

Subprogram	Description
CREATE_AGENT Procedure	This procedure creates an agent.
CREATE_AGENT Attributes	Provides attributes for creating an agent.
ENABLE_AGENT Procedure	This procedure enables an agent.
DISABLE_AGENT Procedure	This procedure disables an agent.
DROP_AGENT Procedure	This procedure drops an existing agent.
CREATE_TASK Procedure	This procedure creates a task that an agent and agent team can include.
CREATE_TASK Attributes	Provides attributes for creating an agent task.
ENABLE_TASK Procedure	This procedure enables an agent task.
DISABLE_TASK Procedure	This procedure disables an agent task.
DROP_TASK Procedure	This procedure drops an existing agent task.
CREATE_TOOL Procedure	This procedure creates custom tools that an agent can include.
CREATE_TOOL Attributes	Provides attributes for creating tools.
ENABLE_TOOL Procedure	This procedure enables a registered tool.
DISABLE_TOOL Procedure	This procedure disables a registered tool.
DROP_TOOL Procedure	This procedure drops an existing tool.
CREATE_TEAM Procedure	This procedure creates an agent team and includes agents and tasks.
CREATE_TEAM Attributes	Provides attributes for creating an agent team.
SET_TEAM Function	This procedure sets the agent team in the current session.
GET_TEAM Function	This procedure returns the agent team set in the current session.
CLEAR_TEAM Function	This procedure clears the agent team set in the current session.
RUN_TEAM Function	This procedure creates a new agent or runs a paused one.
ENABLE_TEAM Procedure	This procedure enables an agent team.
DISABLE_TEAM Procedure	This procedure disables an agent team.
DROP_TEAM Procedure	This procedure drops an existing agent team.