Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows
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
Dependencies
DBMS_CLOUD
DBMS_CLOUD_INTERNAL
JSON_OBJECT_T
DBMS_CLOUD_ADMIN
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