Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_INTERNAL Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai will be available on generic Linux platforms in January and soon on AIX and Windows

Purpose Undocumented

AUTHID DEFINER

Dependencies

DBA_CREDENTIALS	DBMS_LOB	ODCIVARCHAR2LIST
DBA_DIRECTORIES	DBMS_PDB_LIB	PLITBLM
DBMS_ASSERT	DBMS_SQL	UTL_FILE
DBMS_CLOUD	DBMS_STANDARD	UTL_HTTP
DBMS_CLOUD_ADMIN	DBMS_SYS_SQL	UTL_RAW
DBMS_CLOUD_ADMIN_INTERNAL	JSON_ARRAY_T	UTL_URL
DBMS_CLOUD_CORE	JSON_ELEMENT_T	XMLTYPE
DBMS_CLOUD_REQUEST	JSON_KEY_LIST	XQSEQUENCE
DBMS_CLOUD_TYPES	JSON_OBJECT_T

Documented No

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

CACHE_REST_API_RESULTS	DROP_CREDENTIAL	LIST_OBJECTS
CLEAR_BYPASS	DROP_EXTERNAL_TABLE	LIST_OBJECTS_TABFUNC
CONVERT_COMMA_STR2STRLIST	ENABLE_CREDENTIAL	PUT_OBJECT
CREATE_CREDENTIAL	GET_API_RESULT_CACHE_SIZE	READ_FILE
DELETE_FILE	GET_CREATE_EXTTAB_TEXT	SET_API_RESULT_CACHE_SIZE
DELETE_LOAD_OPERATION	GET_METADATA	UPDATE_CREDENTIAL
DELETE_OBJECT	GET_OBJECT	UPDATE_RPST_CREDENTIAL
DELETE_PUT_OPERATION	GET_OBJECT_TABFUNC	WRITE_FILE
DISABLE_CREDENTIAL	LIST_FILES

CACHE_REST_API_RESULTS (new 23ai)

Undocumented dbms_cloud_internal.cache_rest_api_results( username IN VARCHAR2, request_uri IN VARCHAR2, timestamp IN TIMESTAMP WITH TIME ZONE, requset_method IN VARCHAR2, request_headers IN CLOB, request_body_text IN CLOB, response_status_code IN NUMBER, response_headers IN CLOB, response_body_text IN CLOB, cache_scope IN VARCHAR2);

TBD

CLEAR_BYPASS (new 23ai)

Undocumented dbms_cloud_internal.clear_bypass(bypass_value IN NUMBER);

TBD

CONVERT_COMMA_STR2STRLIST

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 (2 new 23ai overloads, overload 2 has new parameters)

Undocumented

Overload 1 dbms_cloud_internal.create_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, username IN VARCHAR2, password 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, rpst IN VARCHAR2);

TBD

Overload 3 dbms_cloud_internal.create_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, aws_role_arn IN VARCHAR2, external_id_type IN VARCHAR2, max_session_duration IN NUMBER);

TBD

Overload 4 dbms_cloud_internal.create_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, params IN VARCHAR2);

TBD

DELETE_FILE

Undocumented dbms_cloud_internal.delete_file( invoker_schema IN VARCHAR2, directory_name IN VARCHAR2, file_name IN VARCHAR2);

TBD

DELETE_LOAD_OPERATION

Undocumented dbms_cloud_internal.delete_load_operation( id IN NUMBER, username IN VARCHAR2, payload IN CLOB, retval OUT NUMBER);

TBD

DELETE_OBJECT

Undocumented dbms_cloud_internal.delete_object( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, object_uri IN VARCHAR2);

TBD

DELETE_PUT_OPERATION (new 23ai)

Undocumented dbms_cloud_internal.delete_put_operation( id IN NUMBER, username IN VARCHAR2, payload IN CLOB, retval OUT NUMBER);

TBD

DISABLE_CREDENTIAL

Undocumented dbms_cloud_internal.disable_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2);

TBD

DROP_CREDENTIAL

Undocumented dbms_cloud_internal.drop_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2);

TBD

DROP_EXTERNAL_TABLE

Undocumented dbms_cloud_internal.drop_external_table( invoker_schema IN VARCHAR2, table_name IN VARCHAR2, parent_operation IN VARCHAR2);

TBD

ENABLE_CREDENTIAL

Undocumented dbms_cloud_internal.enable_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2);

TBD

GET_API_RESULT_CACHE_SIZE (new 23ai)

Return the API result cache size dbms_cloud_internal.get_api_result_cache_size RETURN NUMBER;

SELECT dbms_cloud_internal.get_api_result_cache_size;

      

      GET_API_RESULT_CACHE_SIZE

      -------------------------

                             10

GET_CREATE_EXTTAB_TEXT (new 23ai parameters)

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, bypass_value OUT NUMBER, base_cred_owner IN VARCHAR2, base_cred_name IN VARCHAR2) RETURN CLOB;

TBD

GET_METADATA

Undocumented dbms_cloud_internal.get_metadata( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, object_uri IN VARCHAR2) RETURN CLOB;

TBD

GET_OBJECT

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

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

Undocumented dbms_cloud_internal.list_files( invoker_schema IN VARCHAR2, directory_name IN VARCHAR2, file_name_filter IN VARCHAR2) RETURN CLOB;

TBD

LIST_OBJECTS

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

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

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

Undocumented dbms_cloud_internal.read_file( invoker_schema IN VARCHAR2, directory_name IN VARCHAR2, file_name IN VARCHAR2) RETURN BLOB;

TBD

SET_API_RESULT_CACHE_SIZE (new 23ai)

Set the API result cache size dbms_cloud_internal.set_api_result_cache_size(cache_size IN NUMBER);

exec dbms_cloud_internal.set_api_result_cache_size(8);

      

      PL/SQL procedure_successfully completed.

UPDATE_CREDENTIAL

Undocumented dbms_cloud_internal.update_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, attribute IN VARCHAR2, value IN VARCHAR2);

TBD

UPDATE_RPST_CREDENTIAL (new 23ai)

Undocumented dbms_cloud_internal.update_rpst_credential( invoker_schema IN VARCHAR2, credential_name IN VARCHAR2, rpst IN VARCHAR2, private_key IN VARCHAR2);

TBD

WRITE_FILE

Undocumented

Exfiltration Able dbms_cloud_internal.write_file( invoker_schema IN VARCHAR2, directory_name IN VARCHAR2, file_name IN VARCHAR2, contents IN BLOB);

TBD