Oracle | DBMS_CLOUD

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

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.