Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_JOB Version 21c

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

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

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

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

Get response parameters pod_cdb_admin_job.get_response_params RETURN json_object_t;

TBD

HANDLE_SCHD_REQUEST_PROC

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

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