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.
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_AGENT Package
The following table lists the attributes 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. |