Oracle Cloud Infrastructure Documentation

Autonomous Database Supplied Package Reference

This appendix provides information about the packages you use with Autonomous 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 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_FUNCTION Package
    The DBMS_CLOUD_FUNCTION package allows you invoke OCI and AWS Lambda remote functions in your Autonomous Database as SQL functions.
  • 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 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 Database.
  • DBMS_CLOUD_MIGRATION Package
    The DBMS_CLOUD_MIGRATION package facilitates the translation of the SQL code from PostgreSQL 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 Pre-Authenticated Request (PAR) URLs for data sets.
  • DBMS_DCAT Package
    The DBMS_DCAT package provides functions and procedures to help Autonomous 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_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.

Parent topic: Reference