Oracle | DBMS_CLOUD

Oracle DBMS_CLOUD_CORE Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Undocumented

AUTHID DEFINER

Dependencies

DATABASE_PROPERTIES	DBMS_CLOUD_INTERNAL	DBMS_UTILITY
DBMS_ASSERT	DBMS_CLOUD_MACADM	JSON_OBJECT_T
DBMS_CLOUD	DBMS_CLOUD_REQUEST	V$MYSTAT
DBMS_CLOUD_ADMIN	DBMS_CLOUD_TASK	V$SESSION
DBMS_CLOUD_ADMIN_INTERNAL	DBMS_STANDARD

Documented No

Exceptions

Error Code	Reason
ORA-20006	Unsupported object store URI - www.dbsecworx.com
ORA-20007	Invalid sql name - <string>
`ORA-21000`	`error number argument to raise_application_error of 0 is out of range`

First Available 21c

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/prvt_cloud_core.plb
{ORACLE_HOME}/rdbms/admin/prvt_cloud_core_body.plb

SQL> @?/rdbms/admin/prvt_cloud_core.plb

      

      Session altered.

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE DBMS_CLOUD_CORE:

      

      LINE/COL ERROR

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

      1/1 PLW-05018: unit DBMS_CLOUD_CORE omitted optional AUTHID clause;

      default value DEFINER used

      

      56/9 PLW-06010: keyword "VALUE" used as a defined name

      82/9 PLW-06010: keyword "NAME" used as a defined name

      106/9 PLW-06010: keyword "NAME" used as a defined name

      107/9 PLW-06010: keyword "VALUE" used as a defined name

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

      

      161/9 PLW-06010: keyword "TYPE" used as a defined name

      190/5 PLW-06010: keyword "TYPE" used as a defined name

      215/5 PLW-06010: keyword "TYPE" used as a defined name

      

      Session altered.

      

      SQL> @?/rdbms/admin/prvt_cloud_core_body.plb

      

      Session altered.

      

      SP2-0810: Package Body created with compilation warnings

      

      Errors for PACKAGE BODY DBMS_CLOUD_CORE:

      

      LINE/COL ERROR

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

      110/9 PLW-06010: keyword "VALUE" used as a defined name

      127/PLW-06010: keyword "NAME" used as a defined name

      146/9 PLW-06010: keyword "NAME" used as a defined name

      147/9 PLW-06010: keyword "VALUE" used as a defined name

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

      

      226/PLW-06010: keyword "TYPE" used as a defined name

      261/5 PLW-06010: keyword "TYPE" used as a defined name

      295/5 PLW-06010: keyword "TYPE" used as a defined name

      

      Session altered.

Subprograms

ASSERT	GET_DB_PROPERTY	GET_QUALIFIED_URI
ASSERT_QUALIFIED_SQL_NAME	GET_DB_VERSION	UNQUOTE_NAME
ASSERT_SIMPLE_SQL_NAME	GET_QUALIFIED_NAME	WHOLE_NUMBER
GET_CURRENT_SESSIONID

ASSERT

Undocumented dbms_cloud_core.assert( condition IN BOOLEAN, proc_name IN VARCHAR2, msg IN VARCHAR2);

TBD

ASSERT_QUALIFIED_SQL_NAME

Undocumented dbms_cloud_core.assert_qualified_sql_name( str IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_cloud_core.assert_qualified_sql_name('0ABC');

      *

      ORA-20007: Invalid sql name - 0ABC

ASSERT_SIMPLE_SQL_NAME

Undocumented dbms_cloud_core.assert_simple_sql_name( str IN VARCHAR2, type IN VARCHAR2, max_length IN NUMBER) RETURN VARCHAR2;

SELECT dbms_cloud_core.assert_simple_sql_name('0ABCDEFGHIJKLMNOPQRST', NULL, 10);

      *

      ORA-21000: error number argument to raise_application_error of 0 is out of range

GET_CURRENT_SESSIONID

Returns the SID and SERIAL# for the current session dbms_cloud_core.get_current_sessionid( sid OUT NUMBER, serial# OUT NUMBER);

DECLARE

       sidOut v_$session.sid%TYPE;

       serOut v_$session.serial#%TYPE;

      BEGIN

        dbms_cloud_core.get_current_sessionid(sidOut, serOut);

        dbms_output.put_line(sidOut);

        dbms_output.put_line(serOut);

      END;

      /

      186

      32960

      

      PL/SQL procedure successfully completed.

GET_DB_PROPERTY

Outputs the value of a parameter dbms_cloud_core.get_db_property( name IN VARCHAR2, value OUT VARCHAR2, signal_error IN BOOLEAN);

DECLARE

       outVal dbms_id;

      BEGIN

        dbms_cloud_core.get_db_property('NLS_DATE_LANGUAGE', outVal, TRUE);

        dbms_output.put_line(outVal);

      END;

      /

      AMERICAN

      

      PL/SQL procedure_successfuly completed.

GET_DB_VERSION (new 23ai)

Undocumented dbms_cloud_core.get_db_version RETURN NUMBER;

SELECT dbms_cloud_core.get_db_version;

      

      GET_DB_VERSION

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

                  23

GET_QUALIFIED_NAME

Undocumented dbms_cloud_core.get_qualified_name( object_name IN VARCHAR2, schema_name IN VARCHAR2, type IN VARCHAR2) RETURN VARCHAR2;

TBD

GET_QUALIFIED_URI

Undocumented dbms_cloud_core.get_qualified_uri(uri IN VARCHAR2) RETURN VARCHAR2;

SELECT dbms_cloud_core.get_qualified_uri('https://www.dbsecworx.com');

      

      DBMS_CLOUD_CORE.GET_QUALIFIED_URI('HTTPS://WWW.DBSECWORX.COM')

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

      https://www.dbsecworx.com

UNQUOTE_NAME

Undocumented dbms_cloud_core.unquote_name( name IN VARCHAR2, max_length IN NUMBER) RETURN VARCHAR2;

SELECT dbms_cloud_core.unquote_name('"TAB$"');

      

      DBMS_CLOUD_CORE.UNQUOTE_NAME('"TAB$"')

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

      TAB$

WHOLE_NUMBER

Undocumented dbms_cloud_core.whole_number(value IN NUMBER) RETURN BOOLEAN;

BEGIN

        IF dbms_cloud_core.whole_number(22.9) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      

        IF dbms_cloud_core.whole_number(23.4) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      F

      T

      

      PL/SQL procedure successfully completed.