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