Oracle | DBMS_CLOUD

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

DATABASE_PROPERTIES	DBMS_STANDARD	V$MYSTAT
DBMS_ASSERT	DBMS_UTILITY	V$SESSION
DBMS_CLOUD	JSON_OBJECT_T

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_CURRENT_SESSIONID	GET_QUALIFIED_URI
ASSERT_QUALIFIED_SQL_NAME	GET_DB_PROPERTY	UNQUOTE_NAME
ASSERT_SIMPLE_SQL_NAME	GET_QUALIFIED_NAME	WHOLE_NUMBER

ASSERT (new 21c)

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

TBD

ASSERT_QUALIFIED_SQL_NAME (new 21c)

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

      FROM dual;

      SELECT dbms_cloud_core.assert_qualified_sql_name('0ABC')

      *

      ERROR at line 1:

      ORA-20007: Invalid sql name - 0ABC

      ORA-06512: at "SYS.DBMS_CLOUD_CORE", line 302

      ORA-06512: at line 1

ASSERT_SIMPLE_SQL_NAME (new 21c)

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)

      FROM dual;

      SELECT dbms_cloud_core.assert_simple_sql_name('0ABCDEFGHIJKLMNOPQRST', NuLL, 10)

      *

      ERROR at line 1:

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

      ORA-06512: at "SYS.DBMS_CLOUD_CORE", line 282

      ORA-06512: at line 1

GET_CURRENT_SESSIONID (new 21c)

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 (new 21c)

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

TBD

GET_QUALIFIED_NAME (new 21c)

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

TBD

GET_QUALIFIED_URI (new 21c)

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

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

      FROM dual;

      

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

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

      https://www.dbsecworx.com

UNQUOTE_NAME (new 21c)

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

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

      FROM dual;

      

      DBMS_CLOUD_CORE.UNQUOTE_NAME('"TAB$"')

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

      TAB$

WHOLE_NUMBER (new 21c)

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

BEGIN

        IF dbms_cloud_core.whole_number(23) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      

        IF dbms_cloud_core.whole_number(21.3) THEN

          dbms_output.put_line('T');

        ELSE

          dbms_output.put_line('F');

        END IF;

      END;

      /

      T

      F

      

      PL/SQL procedure successfully completed.