Oracle POD_CDB_ADMIN_JOB
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 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.
AUTHID DEFINER
Dependencies
ALL_SCHEDULER_JOB_RUN_DETAILS DBMS_SCHEDULER JSON_OBJECT_T
DATABASE_PROPERTIES DBMS_SQL POD_ADMIN_ASYNC_JOBSTAT_V2$
DBMS_APPLICATION_INFO DBMS_UTILITY POD_ADMIN_DEFAULT_PARAM$
DBMS_ASSERT JSON_ARRAY_T POD_CDB_ADMIN_COMMON
DBMS_LOCK JSON_ELEMENT_T TAB
Documented No
First Available Not known
Security Model Owned by SYS with no privileges granted
Source {ORACLE_HOME}/rdbms/admin/pod_cdb_admin_job_spec.sql
{ORACLE_HOME}/rdbms/admin/pod_cdb_admin_job.plb
SQL> @?/rdbms/admin/pod_cdb_admin_job_spec.sql

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
Subprograms
 
CREATE_JOB_STATE_TABLE (new 21c)
Creates the new job status table pod_cdb_admin_job.create_job_state_table;
exec pod_cdb_admin_job.create_job_state_table;
 
GET_ASYNC_JOB_STATUS (new 21c)
Async Job Status pod_cdb_admin_job.get_async_job_status(status OUT CLOB);
DECLARE
 outVal CLOB;
BEGIN
  pod_cdb_admin_job.get_async_job_status(outVal);
  dbms_output.put_line(outVal);
END;
/
 
GET_RESPONSE_PARAMS (new 21c)
Get response parameters pod_cdb_admin_job.get_response_params RETURN json_object_t;
TBD
 
HANDLE_SCHD_REQUEST_PROC (new 21c)
Scheduled incoming requests as a sync/async job 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);
TBD
 
INVOKE_SCHD_HANDLE_PROC (new 21c)
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);
TBD

Related Topics
Built-in Functions
Built-in Packages
Database Security
POD_CDB_ADMIN
POD_CDB_ADMIN_COMMON
POD_CDB_ADMIN_HTTP
POD_CDB_ADMIN_UTIL
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