Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_REQUEST Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_LOCK	UTL_ENCODE
DBMS_CLOUD	DBMS_PDB_LIB	UTL_HTTP
DBMS_CLOUD_ADMIN	DBMS_RANDOM	UTL_I18N
DBMS_CLOUD_CAPABILITY	DBMS_STANDARD	UTL_RAW
DBMS_CLOUD_CORE	DBMS_UTILITY	UTL_TCP
DBMS_CLOUD_INTERNAL	JSON_KEY_LIST	UTL_URL
DBMS_CLOUD_STORE	JSON_OBJECT_T	XMLTYPE
DBMS_CRYPTO	PLITBLM	XQSEQUENCE
DBMS_LOB

Documented No

First Available 21c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_request.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_request_body.plb

SQL> @?/rdbms/admin/prvt_cloud_request.plb

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_REQUEST:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      1/1 PLW-05018: unit DBMS_CLOUD_REQUEST omitted optional AUTHID

      clause; default value DEFINER used

      113/5 PLW-06010: keyword "CONTEXT" used as a defined name

      113/5 PLW-07203: parameter 'CONTEXT' may benefit from use of the NOCOPY compiler hint

      115/5 PLW-06010: keyword "BODY" used as a defined name

      150/5 PLW-07203: parameter 'RESP' may benefit from use of the NOCOPY compiler hint

      169/5 PLW-06010: keyword "CONTEXT" used as a defined name

      191/5 PLW-06010: keyword "CONTEXT" used as a defined name

      

      Session altered.

      

      SQL> @?/rdbms/admin/prvt_cloud_request_body.plb

      

      Session altered.

      

      Warning: Package Body created with compilation errors.

      

      Errors for PACKAGE BODY DBMS_CLOUD_REQUEST:

      

      LINE/COL ERROR

      ------------------------------------------------------------------------

      0/0 PL/SQL: Compilation unit analysis terminated

      95/5 PLW-07203: parameter 'VERSION' may benefit from use of the NOCOPY compiler hint

      121/PLW-07203: parameter 'OWNER_NAME' may benefit from use of the NOCOPY compiler hint

      122/PLW-07203: parameter 'CREDENTIAL_NAME' may benefit from use of the NOCOPY compiler hint

      246/5 PLW-07203: parameter 'URI' may benefit from use of the NOCOPY compiler hint

      354/5 PLW-07203: parameter 'URI' may benefit from use of the NOCOPY compiler hint

      504/5 PLW-07203: parameter 'REQ' may benefit from use of the NOCOPY compiler hint

      587/5 PLW-07203: parameter 'VERSION' may benefit from use of the NOCOPY compiler hint

      590/21 PLS-00201: identifier 'DBMS_CLOUD_STORE.CLOUD_TYPE' must be declared

      

      Session altered.

Subprograms

CLEAR_CACHE	GET_URI_FILE_PATH	REFRESH_RESOURCE_PRINCIPAL
END_REQUEST	INIT_REQUEST	SEND_REQUEST
GET_CLOUD_STORE_TYPE

CLEAR_CACHE

Undocumented dbms_cloud_request.clear_cache;

exec dbms_cloud_request.clear_cache;

      

      PL/SQL procedure successfully completed.

END_REQUEST

Undocumented dbms_cloud_request.end_request(resp IN OUT sys.utl_http.resp);

TBD

GET_CLOUD_STORE_TYPE

Undocumented dbms_cloud_request.get_cloud_store_type( context IN sys.dbms_cloud_request.request_context_t) RETURN BINARY_INTEGER;

TBD

GET_URI_FILE_PATH

Undocumented dbms_cloud_request.get_uri_file_path( context IN sys.dbms_cloud_request.request_context_t) RETURN VARCHAR2;

TBD

INIT_REQUEST

Undocumented dbms_cloud_request.init_request( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, base_uri IN VARCHAR2, method IN VARCHAR2) RETURN sys.dbms_cloud_request.request_context_t;

TBD

REFRESH_RESOURCE_PRINCIPAL (new 23ai)

Undocumented dbms_cloud_request.refresh_resouce_principal;


      dbms_cloud_request.refresh_resouce_principal;

      

      PL/SQL procedure successfully completed.

SEND_REQUEST

Undocumented dbms_cloud_request.send_request( context IN OUT sys.dbms_cloud_request.request_context_t, path IN VARCHAR2, body IN BLOB, headers IN sys.json_object_t, params IN sys.json_object_t, use_bucket_uri IN BOOLEAN, bfile_locator IN BFILE) RETURN sys.utl_http.resp;

TBD