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 (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.

Related Topics
Built-in Functions
Built-in Packages
Database Security
DBMS_CLOUD
DBMS_CLOUD_ADMIN_INTERNAL
DBMS_CLOUD_CAPABILITY
DBMS_CLOUD_INTERNAL
DBMS_CLOUD_MACADM
DBMS_CLOUD_REQUEST
DBMS_CLOUD_TASK
DBMS_CLOUD_TYPES
What's New In 19c
What's New In 20c-21c

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2019 Daniel A. Morgan All Rights Reserved
  DBSecWorx