Oracle | DBMS_CLOUD

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

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	DROP_EXTERNAL_TABLE	LIST_OBJECTS
CREATE_CREDENTIAL 2	ENABLE_CREDENTIAL	LIST_OBJECTS_TABFUNC
DELETE_FILE	GET_CREATE_EXTTAB_TEXT	PUT_OBJECT
DELETE_LOAD_OPERATION	GET_METADATA	READ_FILE
DELETE_OBJECT	GET_OBJECT	UPDATE_CREDENTIAL
DISABLE_CREDENTIAL	GET_OBJECT_TABFUNC	WRITE_FILE
DROP_CREDENTIAL	LIST_FILES

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