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
Implements helper APIs that must to be installed as common in an Autonomous Database.
The source for the PL/SQL package CLOUD_LOGGER, owned by C##CLOUD$SERVICE in the Autonomous Database, could not be found so a valid deployment of this package was not possible and the demos below untested.
SP2-0808: Package created with compilation warnings
Errors for PACKAGE POD_CDB_ADMIN_JOB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
1/1 PLW-05018: unit POD_CDB_ADMIN_JOB omitted optional AUTHID clause;
default value DEFINER used
12/37 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
51/32 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
SQL> @?/rdbms/admin/pod_cdb_admin_job.plb
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY POD_CDB_ADMIN_JOB:
LINE/COL ERROR
-------- -----------------------------------------------------------------
39/37 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
156/2 PL/SQL: Statement ignored
156/2 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
164/2 PL/SQL: Statement ignored
164/2 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
197/3 PL/SQL: Statement ignored
197/3 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
230/4 PL/SQL: Statement ignored
230/4 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
233/7 PL/SQL: Statement ignored
233/7 PLS-00201: identifier 'CLOUD_LOGGER.ERROR' must be declared
234/7 PL/SQL: Statement ignored
234/7 PLS-00201: identifier 'CLOUD_LOGGER.ERROR' must be declared
239/7 PL/SQL: Statement ignored
239/7 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
260/3 PL/SQL: Statement ignored
260/3 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
272/3 PL/SQL: Statement ignored
272/3 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared
275/7 PL/SQL: Statement ignored
275/7 PLS-00201: identifier 'CLOUD_LOGGER.ERROR' must be declared
382/32 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPYcompiler hint
531/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
824/37 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
1218/37 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint
pod_cdb_admin_job.handle_schd_request_proc(
invoke_str IN VARCHAR2,
req_id IN VARCHAR2,
req_params IN VARCHAR2,
req_payload IN CLOB,
req_version IN VARCHAR2,
ret_status IN BOOLEAN,
status OUT CLOB);
Invoked by scheduled job which may be a reference to the HANDLE_SCHD... proc above but that is not clear
pod_cdb_admin_job.invoke_schd_handle_proc(
req_id IN VARCHAR2,
req_method IN VARCHAR2,
req_uri IN VARCHAR2,
req_params IN VARCHAR2,
req_payload_fmt IN VARCHAR2,
req_version IN VARCHAR2,
job_id IN VARCHAR2,
response_url IN VARCHAR2,
token IN VARCHAR2,
sqlstmt IN VARCHAR2);