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