Oracle Cloud Infrastructure Documentation

Autonomous AI Database Supplied Package Reference

This appendix provides information about the packages you use with Autonomous AI Database. The DBMS_CLOUD topic also covers the DBMS_CLOUD REST APIs.

  • DBMS_CLOUD Package
    The DBMS_CLOUD package provides database routines for working with cloud resources.
  • DBMS_CLOUD_ADMIN Package
    The DBMS_CLOUD_ADMIN package provides administrative routines for configuring a database.
  • DBMS_CLOUD_AI Package
    The DBMS_CLOUD_AI package, with Select AI, facilitates and configures the translation of natural language prompts to generate, run, explain SQL statements. Also, enables retrieval augmented generation and natural language-based interactions, including chatting with LLMs.
  • DBMS_CLOUD_AI_AGENT Package
    This package defines and manages Select AI agents, tasks, tools, and orchestration.
  • DBMS_CLOUD_FUNCTION Package
    The DBMS_CLOUD_FUNCTION package allows you invoke OCI and AWS Lambda remote functions in your Autonomous AI Database as SQL functions.
  • DBMS_CLOUD_FUNCTION_ADMIN Package
    The DBMS_CLOUD_FUNCTION_ADMIN package supports you invoking generic scripts from an Autonomous AI Database instance.
  • DBMS_CLOUD_LINK Package
    The DBMS_CLOUD_LINK package allows a user to register a table or a view as a data set for read only access with Cloud Links.
  • DBMS_CLOUD_LINK_ADMIN Package
    The DBMS_CLOUD_LINK_ADMIN package allows the ADMIN user to enable a database user to register data sets or to access registered data sets for a given Autonomous AI Database instance, subject to the access restrictions as defined with the granted scope.
  • DBMS_CLOUD_MACADM Package
    This section covers the DBMS_CLOUD_MACADM subprograms provided with Autonomous AI Database.
  • DBMS_CLOUD_MIGRATION Package
    The DBMS_CLOUD_MIGRATION package facilitates translation of the SQL code from a non-Oracle SQL flavor to Oracle SQL.
  • DBMS_CLOUD_NOTIFICATION Package
    The DBMS_CLOUD_NOTIFICATION package allows you to send messages or the output of a SQL query to a provider.
  • DBMS_CLOUD_PIPELINE Package
    The DBMS_CLOUD_PIPELINE package allows you to create data pipelines for loading and exporting data in the cloud. This package supports continuous incremental data load of files in object store into the database. DBMS_CLOUD_PIPELINE also supports continuous incremental export of table data or query results from the database to object store based on a timestamp column.
  • DBMS_CLOUD_REPO Package
    The DBMS_CLOUD_REPO package provides for use of and management of cloud hosted code repositories from Oracle Database. Supported cloud code repositories include GitHub, AWS CodeCommit , and Azure Repos.
  • DBMS_AUTO_PARTITION Package
    The DBMS_AUTO_PARTITION package provides administrative routines for managing automatic partitioning of schemas and tables.
  • DBMS_DATA_ACCESS Package
    The DBMS_DATA_ACCESS package provides routines to generate and manage Table Hyperlinks for data sets.
  • DBMS_DCAT Package
    The DBMS_DCAT package provides functions and procedures to help Autonomous AI Database users leverage the data discovery and centralized metadata management system of OCI Data Catalog.
  • DBMS_INMEMORY_ADMIN Package
    The DBMS_INMEMORY_ADMIN package enables you to manage the In-Memory area and In-Memory FastStart.
  • DBMS_MAX_STRING_SIZE Package
    The DBMS_MAX_STRING_SIZE package provides an interface for checking and changing the value of the DBMS_MAX_STRING_SIZE initialization parameter.
  • DBMS_PIPE Package
    The DBMS_PIPE package lets two or more sessions in the same instance communicate.
  • DBMS_PROXY_SQL
    Describes the procedures to enable and disable query offload for an elastic pool leader or an elastic pool member. This package also provides procedures to enable and manage ProxySQL for statement routing.
  • DBMS_SHARE Package
    The DBMS_SHARE subprograms and views are used to share local data with external systems.
  • CS_RESOURCE_MANAGER Package
    The CS_RESOURCE_MANAGER package provides an interface to list and update consumer group parameters, and to revert parameters to default values.
  • CS_SESSION Package
    The CS_SESSION package provides an interface to switch the database service and consumer group of the existing session.
  • DBMS_EXT_TABLE_CACHE Package
    The DBMS_EXT_TABLE_CACHE package provides routines to configure and manage caching of frequently accessed data from external tables into Autonomous AI Database.

Parent topic: Reference