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 will be available on generic Linux platforms in January and soon on AIX and Windows

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.