Oracle DBMS_CLOUD_INTERNAL
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
DBA_CREDENTIALS DBMS_DB_VERSION ODCIVARCHAR2LIST
DBA_DIRECTORIES DBMS_LOB PLITBLM
DBMS_ASSERT DBMS_METADATA UTL_COMPRESS
DBMS_CLOUD DBMS_PDB_LIB UTL_FILE
DBMS_CLOUD_CAPABILITY DBMS_STANDARD UTL_HTTP
DBMS_CLOUD_CORE JSON_ARRAY_T UTL_RAW
DBMS_CLOUD_REQUEST JSON_ELEMENT_T UTL_URL
DBMS_CLOUD_TASK JSON_KEY_LIST XMLTYPE
DBMS_CLOUD_TYPES JSON_OBJECT_T XQSEQUENCE
DBMS_CREDENTIAL KUBSD$DESC_INT  
Documented No
Exceptions
Error Code Reason
   
   
   
First Available 21c
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_internal.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_internal_body.plb
SQL> @?/rdbms/admin/prvt_cloud_internal.plb

Session altered.

SP2-0808: Package created with compilation warnings

Errors for PACKAGE DBMS_CLOUD_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit DBMS_CLOUD_INTERNAL omitted optional AUTHID
clause; default value DEFINER used

187/9 PLW-06010: keyword "ATTRIBUTE" used as a defined name
188/9 PLW-06010: keyword "VALUE" used as a defined name
235/9 PLW-06010: keyword "FORMAT" used as a defined name
557/9 PLW-07203: parameter 'FILTER_PATH' may benefit from use of the NOCOPY compiler hint
558/9 PLW-07203: parameter 'LIST_FIELDS' may benefit from use of the NOCOPY compiler hint

Grant succeeded.

Synonym created.

Session altered.

Session altered.

Warning: Package Body created with compilation errors.

Errors for PACKAGE BODY DBMS_CLOUD_INTERNAL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
748/9 PLW-07203: parameter 'RECORD_PARAMETERS' may benefit from use of
the NOCOPY compiler hint

749/9 PLW-07203: parameter 'FIELD_PARAMETERS' may benefit from use of
the NOCOPY compiler hint

889/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint

890/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint

891/9 PLW-07203: parameter 'SCHEMA_STRATEGY' may benefit from use of
the NOCOPY compiler hint

1051/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint

1052/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint

1258/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint

1259/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint

2030/3 PL/SQL: Item ignored
2031/31 PLS-00201: identifier 'DBMS_CLOUD_REQUEST.REQUEST_CONTEXT_T' must be declared

2065/6 PLW-07203: parameter 'USERNAME' may benefit from use of the NOCOPY compiler hint

2066/6 PLW-07203: parameter 'PASSWORD' may benefit from use of the NOCOPY compiler hint

2067/6 PLW-07203: parameter 'KEY' may benefit from use of the NOCOPY
compiler hint

2186/9 PLW-07203: parameter 'L_LOG_JSON_OBJ' may benefit from use of the
NOCOPY compiler hint

2460/24 PLS-00201: identifier 'DBMS_CLOUD_REQUEST.REQUEST_CONTEXT_T' must be declared

Session altered.
Subprograms
 
CONVERT_COMMA_STR2STRLIST (new 21c)
Converts a comma delimited list of values into a varray dbms_cloud_internal.convert_comma_str2strlist(
p_comma_string IN CLOB,
p_item_string  IN VARCHAR2,
p_max_length   IN NUMBER)
RETURN  sys.odcivarchar2list;
DECLARE
 inStrng CLOB := 'M,o,r,g,a,n';
 strList sys.odcivarchar2list;
BEGIN
  strList := dbms_cloud_internal.convert_comma_str2strlist(inStrng, NULL, 100);
  FOR i IN 1 .. 6 LOOP
    dbms_output.put_line(strList(i));
  END LOOP;
END;
/
M
o
r
g
a
n

PL/SQL procedure successfully completed.
 
CREATE_CREDENTIAL (new 21c)
Undocumented

Overload 1
dbms_cloud_internal.create_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
username        IN VARCHAR2,
password        IN VARCHAR2,
invoker_schema  IN VARCHAR2);
TBD
Overload 2 dbms_cloud_internal.create_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
user_ocid       IN VARCHAR2,
tenancy_ocid    IN VARCHAR2,
private_key     IN VARCHAR2,
fingerprint     IN VARCHAR2,
passphrase      IN VARCHAR2);
TBD
 
DELETE_FILE (new 21c)
Undocumented dbms_cloud_internal.delete_file(
invoker_schema IN VARCHAR2,
directory_name IN VARCHAR2,
file_name      IN VARCHAR2);
TBD
 
DELETE_LOAD_OPERATION (new 21c)
Undocumented dbms_cloud_internal.delete_load_operation(
id       IN  NUMBER,
username IN  VARCHAR2,
payload  IN  CLOB,
retval   OUT NUMBER);
TBD
 
DELETE_OBJECT (new 21c)
Undocumented dbms_cloud_internal.delete_object(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2);
TBD
 
DISABLE_CREDENTIAL (new 21c)
Undocumented dbms_cloud_internal.disable_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2);
TBD
 
DROP_CREDENTIAL (new 21c)
Undocumented dbms_cloud_internal.drop_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2);
TBD
 
DROP_EXTERNAL_TABLE (new 21c)
Undocumented dbms_cloud_internal.drop_external_table(
invoker_schema   IN VARCHAR2,
table_name       IN VARCHAR2,
parent_operation IN VARCHAR2);
TBD
 
ENABLE_CREDENTIAL (new 21c)
Undocumented dbms_cloud_internal.enable_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2);
TBD
 
GET_CREATE_EXTTAB_TEXT (new 21c)
Undocumented dbms_cloud_internal.get_create_exttab_text(
invoker_schema      IN VARCHAR2,
table_name          IN VARCHAR2,
credential_name     IN VARCHAR2,
file_uri_list       IN CLOB,
partitioning_clause IN CLOB,
column_list         IN CLOB,
base_table          IN VARCHAR2,
base_table_schema   IN VARCHAR2,
field_list          IN CLOB,
format              IN CLOB,
log_dir             IN VARCHAR2,
log_file_prefix     IN VARCHAR2,
os_ext_table        IN BOOLEAN,
parent_operation    IN VARCHAR2,
part_table          IN BOOLEAN,
hybrid_table        IN BOOLEAN,
export_query        IN CLOB)
RETURN CLOB;
TBD
 
GET_METADATA (new 21c)
Undocumented dbms_cloud_internal.get_metadata(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2)
RETURN CLOB;
TBD
 
GET_OBJECT (new 21c)
Undocumented

Overload 1
dbms_cloud_internal.get_object(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2,
startoffset     IN NUMBER,
endoffset       IN NUMBER,
compression     IN VARCHAR2)
RETURN BLOB;
TBD
Overload 2 dbms_cloud_internal.get_object(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2,
directory_name  IN VARCHAR2,
file_name       IN VARCHAR2,
startoffset     IN NUMBER,
endoffset       IN NUMBER,
compression     IN VARCHAR2)
RETURN BLOB;
TBD
 
GET_OBJECT_TABFUNC (new 21c)
Undocumented dbms_cloud_internal.get_object_tabfunc(
arguments_ptr IN RAW,
contents_ptr  IN RAW)
RETURN sys.dbms_cloud_types.get_object_ret_tab;
TBD
 
LIST_FILES (new 21c)
Undocumented dbms_cloud_internal.list_files(
invoker_schema   IN VARCHAR2,
directory_name   IN VARCHAR2,
file_name_filter IN VARCHAR2)
RETURN CLOB;
TBD
 
LIST_OBJECTS (new 21c)
Undocumented dbms_cloud_internal.list_objects(
invoker_schema  IN  VARCHAR2,
credential_name IN  VARCHAR2,
location_uri    IN  VARCHAR2,
resume_obj      IN  VARCHAR2,
filter_path     OUT VARCHAR2,
list_fields     OUT sys.dbms_cloud_types.list_object_fields_t)
RETURN CLOB;
TBD
 
LIST_OBJECTS_TABFUNC (new 21c)
Undocumented dbms_cloud_internal.list_objects_tabfunc(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
location_uri    IN VARCHAR2)
RETURN sys.dbms_cloud_types.list_object_ret_tab;
TBD
 
PUT_OBJECT (new 21c)
Undocumented

Overload 1
dbms_cloud_internal.put_object(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2,
contents        IN BLOB,
compression     IN VARCHAR2);
TBD
Overload 2 dbms_cloud_internal.put_object(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri      IN VARCHAR2,
directory_name  IN VARCHAR2,
file_name       IN VARCHAR2,
compression     IN VARCHAR2);
TBD
 
READ_FILE (new 21c)
Undocumented dbms_cloud_internal.read_file(
invoker_schema IN VARCHAR2,
directory_name IN VARCHAR2,
file_name      IN VARCHAR2)
RETURN BLOB;
TBD
 
UPDATE_CREDENTIAL (new 21c)
Undocumented dbms_cloud_internal.update_credential(
invoker_schema  IN VARCHAR2,
credential_name IN VARCHAR2,
attribute       IN VARCHAR2,
value           IN VARCHAR2);
TBD
 
WRITE_FILE (new 21c)
Undocumented dbms_cloud_internal.write_file(
invoker_schema IN VARCHAR2,
directory_name IN VARCHAR2,
file_name      IN VARCHAR2,
contents IN BLOB);
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_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 19c
What's New In 20c-21c

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-2021 Daniel A. Morgan All Rights Reserved
  DBSecWorx