Oracle | DBMS_CLOUD

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