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 SQL statements.
• 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_NOTIFICATION Package
  The DBMS_CLOUD_NOTIFICATION package allows you to send messages or the output of a SQL query to a provider.
• DBMS_DATA_ACCESS Package
  The DBMS_DATA_ACCESS package provides routines to generate and manage Pre-Authenticated Request (PAR) URLs for data sets.
• DBMS_PIPE Package
  The DBMS_PIPE package lets two or more sessions in the same instance communicate.
• 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_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_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_AUTO_PARTITION Package
  The DBMS_AUTO_PARTITION package provides administrative routines for managing automatic partitioning of schemas and tables.
• 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_SHARE Package
  The DBMS_SHARE subprograms and views are used to share local data with external systems.