Oracle DBMS_CLOUD_TYPES
Version 21c

General Information
Library Note Morgan's Library Page Header
Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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 {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 19c
What's New In 20c-21c

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-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx