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.
SP2-0808: Package created with compilation warnings
Errors for PACKAGE DBMS_CLOUD_INTERNAL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit DBMS_CLOUD_INTERNAL omitted optional AUTHID
clause; default value DEFINER used
187/9 PLW-06010: keyword "ATTRIBUTE" used as a defined name
188/9 PLW-06010: keyword "VALUE" used as a defined name
235/9 PLW-06010: keyword "FORMAT" used as a defined name
557/9 PLW-07203: parameter 'FILTER_PATH' may benefit from use of the NOCOPY compiler hint
558/9 PLW-07203: parameter 'LIST_FIELDS' may benefit from use of the NOCOPY compiler hint
Grant succeeded.
Synonym created.
Session altered.
Session altered.
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY DBMS_CLOUD_INTERNAL:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PL/SQL: Compilation unit analysis terminated
748/9 PLW-07203: parameter 'RECORD_PARAMETERS' may benefit from use of
the NOCOPY compiler hint
749/9 PLW-07203: parameter 'FIELD_PARAMETERS' may benefit from use of
the NOCOPY compiler hint
889/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint
890/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint
891/9 PLW-07203: parameter 'SCHEMA_STRATEGY' may benefit from use of
the NOCOPY compiler hint
1051/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint
1052/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint
1258/9 PLW-07203: parameter 'ACCESS_PARAMETERS' may benefit from use of
the NOCOPY compiler hint
1259/9 PLW-07203: parameter 'REJECT_LIMIT_CLAUSE' may benefit from use
of the NOCOPY compiler hint
2030/3 PL/SQL: Item ignored
2031/31 PLS-00201: identifier 'DBMS_CLOUD_REQUEST.REQUEST_CONTEXT_T' must be declared
2065/6 PLW-07203: parameter 'USERNAME' may benefit from use of the NOCOPY compiler hint
2066/6 PLW-07203: parameter 'PASSWORD' may benefit from use of the NOCOPY compiler hint
2067/6 PLW-07203: parameter 'KEY' may benefit from use of the NOCOPY
compiler hint
2186/9 PLW-07203: parameter 'L_LOG_JSON_OBJ' may benefit from use of the
NOCOPY compiler hint
2460/24 PLS-00201: identifier 'DBMS_CLOUD_REQUEST.REQUEST_CONTEXT_T' must be declared
Converts a comma delimited list of values into a varray
dbms_cloud_internal.convert_comma_str2strlist(
p_comma_string IN CLOB,
p_item_string IN VARCHAR2,
p_max_length IN NUMBER)
RETURN sys.odcivarchar2list;
DECLARE
inStrng CLOB := 'M,o,r,g,a,n';
strList sys.odcivarchar2list;
BEGIN
strList := dbms_cloud_internal.convert_comma_str2strlist(inStrng, NULL, 100);
FOR i IN 1 .. 6 LOOP
dbms_output.put_line(strList(i));
END LOOP;
END;
/ M
o
r
g
a
n
dbms_cloud_internal.create_credential(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
username IN VARCHAR2,
password IN VARCHAR2,
invoker_schema IN VARCHAR2);
TBD
Overload 2
dbms_cloud_internal.create_credential(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
user_ocid IN VARCHAR2,
tenancy_ocid IN VARCHAR2,
private_key IN VARCHAR2,
fingerprint IN VARCHAR2,
passphrase IN VARCHAR2);
dbms_cloud_internal.get_create_exttab_text(
invoker_schema IN VARCHAR2,
table_name IN VARCHAR2,
credential_name IN VARCHAR2,
file_uri_list IN CLOB,
partitioning_clause IN CLOB,
column_list IN CLOB,
base_table IN VARCHAR2,
base_table_schema IN VARCHAR2,
field_list IN CLOB,
format IN CLOB,
log_dir IN VARCHAR2,
log_file_prefix IN VARCHAR2,
os_ext_table IN BOOLEAN,
parent_operation IN VARCHAR2,
part_table IN BOOLEAN,
hybrid_table IN BOOLEAN,
export_query IN CLOB)
RETURN CLOB;
dbms_cloud_internal.get_object(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri IN VARCHAR2,
startoffset IN NUMBER,
endoffset IN NUMBER,
compression IN VARCHAR2)
RETURN BLOB;
TBD
Overload 2
dbms_cloud_internal.get_object(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri IN VARCHAR2,
directory_name IN VARCHAR2,
file_name IN VARCHAR2,
startoffset IN NUMBER,
endoffset IN NUMBER,
compression IN VARCHAR2)
RETURN BLOB;
dbms_cloud_internal.list_objects(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
location_uri IN VARCHAR2,
resume_obj IN VARCHAR2,
filter_path OUT VARCHAR2,
list_fields OUT
sys.dbms_cloud_types.list_object_fields_t)
RETURN CLOB;
dbms_cloud_internal.list_objects_tabfunc(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
location_uri IN VARCHAR2)
RETURN sys.dbms_cloud_types.list_object_ret_tab;
dbms_cloud_internal.put_object(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri IN VARCHAR2,
contents IN BLOB,
compression IN VARCHAR2);
TBD
Overload 2
dbms_cloud_internal.put_object(
invoker_schema IN VARCHAR2,
credential_name IN VARCHAR2,
object_uri IN VARCHAR2,
directory_name IN VARCHAR2,
file_name IN VARCHAR2,
compression IN VARCHAR2);