Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_JOB Version 21c

General Information

Library Note

Morgan's Library Page Header

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.

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	GET_RESPONSE_PARAMS	INVOKE_SCHD_HANDLE_PROC
GET_ASYNC_JOB_STATUS	HANDLE_SCHD_REQUEST_PROC

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