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 (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

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_CORE
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 21c
What's New In 23c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2023 Daniel A. Morgan All Rights Reserved
  DBSecWorx