Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_REQUEST 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 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