Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_REQUEST Version 21c

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 Undocumented

AUTHID DEFINER

Dependencies

DBMS_ASSERT	DBMS_LOB	PLITBLM
DBMS_CLOUD	DBMS_LOCK	UTL_ENCODE
DBMS_CLOUD_CORE	DBMS_PDB_LIB	UTL_HTTP
DBMS_CLOUD_INTERNAL	DBMS_STANDARD	UTL_I18N
DBMS_CLOUD_STORE	JSON_KEY_LIST	UTL_RAW
DBMS_CRYPTO	JSON_OBJECT_T

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_CLOUD_STORE_TYPE	INIT_REQUEST
END_REQUEST	GET_URI_FILE_PATH	SEND_REQUEST

CLEAR_CACHE (new 21c)

Undocumented dbms_cloud_request.clear_cache;

exec dbms_cloud_request.clear_cache;

      

      PL/SQL procedure successfully completed.

END_REQUEST (new 21c)

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

TBD

GET_CLOUD_STORE_TYPE (new 21c)

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 (new 21c)

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

TBD

INIT_REQUEST (new 21c)

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

SEND_REQUEST (new 21c)

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