Oracle DBMS_CLOUD_TYPES
Version 23c

General Information
Library Note Morgan's Library Page Header
ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling complimentary technical Workshops on Database Security for the first 30 Oracle Database customers located anywhere in North America, EMEA, LATAM, or APAC that send an email to asra_us@oracle.com. Request a Workshop for your organization today.
Purpose Data Types Supporting Oracle Cloud Database Deployments
AUTHID CURRENT_USER
Constants
Name Data Type Value
 General
M_IDEN PLS_INTEGER 128
 M_VCSIZ_4K PLS_INTEGER 4000
Data Types -- Type for return value from list_objects table function

TYPE list_object_ret_t IS RECORD(
  object_name   VARCHAR2(M_VCSIZ_4K),
  bytes         NUMBER,
  checksum      VARCHAR2(M_IDEN),
  created       TIMESTAMP WITH TIME ZONE,
  last_modified TIMESTAMP WITH TIME ZONE);
TYPE list_object_ret_tab IS TABLE OF list_object_ret_t;

-- Type for return value from get_object table function
TYPE get_object_ret_t IS RECORD (status NUMBER);
TYPE get_object_ret_tab IS TABLE OF get_object_ret_t;

-- Type for return value from get_network_acl function
TYPE network_acl_ret_t IS RECORD(ace VARCHAR2(1024));
TYPE network_acl_ret_tab IS TABLE OF network_acl_ret_t;

-- Associative array for storing field names from the list object response
TYPE list_object_fields_t IS TABLE OF VARCHAR2(M_IDEN)
INDEX BY VARCHAR2(M_IDEN/2);

-- HTTP Response type
TYPE resp IS RECORD (
  headers     JSON_OBJECT_T, -- Response headers as JSON object
  body        BLOB,          -- Response body as a BLOB
  status_code PLS_INTEGER,   -- Response status code
  init        BOOLEAN);      -- Response initialized
Documented No
First Available 20c
Security Model Owned by SYS with EXECUTE granted to PUBLIC
Source

This package is installed by default in 23.2 but was not installed by default in 20c, 21c or 23.1
{ORACLE_HOME}/rdbms/admin/dbms_cloud_types.sql
SQL> @?/rdbms/admin/dbms_cloud_types.sql

Session altered.

SP2-0808: Package created with compilation warnings

Errors for PACKAGE DBMS_CLOUD_TYPES:

LINE/COL ERROR
-------- -----------------------------------------------------------------
15/38 PLW-05004: identifier CHECKSUM is also declared in STANDARD or is
a SQL builtin

44/9 PLW-06010: keyword "BODY" used as a defined name

Synonym created.

Grant succeeded.

Session altered.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx