Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_HTTP 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 Management Utilities for Autonomous Database

A search for the source of the two known dependent objects was unsuccessful.
[oracle@test21 dbhome_1]$ grep -ir "cloud_logger" Binary file lib/libserver.a matches Binary file bin/oracle matches
but no references were found for POD_CDB_ADMIN_HTTP_CORE

AUTHID DEFINER

Dependencies

CLOUD_LOGGER

POD_CDB_ADMIN_HTTP_CORE

Documented No

First Available Not known

Security Model Owned by SYS with no privileges granted

Source {ORACLE_HOME}/rdbms/admin/pod_cdb_admin_http_spec.sql
{ORACLE_HOME}/rdbms/admin/pod_cdb_admin_http.plb

SQL> @?/rdbms/admin/pod_cdb_admin_http_spec.sql

      

      SP2-0808: Package created with compilation warnings

      

      Errors for PACKAGE POD_CDB_ADMIN_HTTP:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      1/1 PLW-05018: unit POD_CDB_ADMIN_HTTP omitted optional AUTHID clause; default value DEFINER used

      20/5 PLW-07203: parameter 'RESPONSE' may benefit from use of the NOCOPY compiler hint

      31/30 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint

      46/5 PLW-07203: parameter 'RESPONSE' may benefit from use of the NOCOPY compiler hint

      58/29 PLW-07203: parameter 'RESPONSE' may benefit from use of the NOCOPY compiler hint

      

      SQL> @?/rdbms/admin/pod_cdb_admin_http.plb

      

      Warning: Package Body created with compilation errors.

      

      Errors for PACKAGE BODY POD_CDB_ADMIN_HTTP:

      

      LINE/COL ERROR

      -------- -----------------------------------------------------------------

      0/0 PL/SQL: Compilation unit analysis terminated

      9/5 PLW-07203: parameter 'STATUS' may benefit from use of the NOCOPY compiler hint

      16/5 PL/SQL: Statement ignored

      16/5 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared

      28/5 PL/SQL: Statement ignored

      28/5 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared

      31/7 PL/SQL: Statement ignored

      31/7 PLS-00201: identifier 'CLOUD_LOGGER.ERROR' must be declared

      32/7 PL/SQL: Statement ignored

      32/7 PLS-00201: identifier 'CLOUD_LOGGER.ERROR' must be declared

      36/7 PL/SQL: Statement ignored

      36/7 PLS-00201: identifier 'CLOUD_LOGGER.SET_MODULE_NAME' must be declared

      47/29 PLW-07203: parameter 'RESPONSE' may benefit from use of the NOCOPY compiler hint

      50/38 PLS-00201: identifier 'POD_CDB_ADMIN_HTTP_CORE.PAYLOAD_LIMIT' must be declared

Subprograms

CHECK_CONNECTION	POST_JOB_REQUEST	POST_JOB_STATUS
GET_JOB_REQUEST

CHECK_CONNECTION (new 21c)

Validate connection pod_cdb_admin_http.check_connection( url IN VARCHAR2, -- URL to receive the message status OUT CLOB); -- connection check response

TBD

GET_JOB_REQUEST (new 21c)

Initiative a get request pod_cdb_admin_http.get_job_request( url IN VARCHAR2, -- URL to receive the message ext_app_name IN VARCHAR2 DEFAULT NULL, -- external app name for token generation ext_app_username IN VARCHAR2 DEFAULT NULL, -- external app username for token generation token IN VARCHAR2 DEFAULT NULL, -- token to use to send the request response OUT VARCHAR2); -- get job request response

TBD

POST_JOB_REQUEST (new 21c)

Intiate a post request pod_cdb_admin_http.post_job_request( url IN VARCHAR2, -- URL to receive the message payload IN VARCHAR2, -- undocumented timeout IN NUMBER DEFAULT 0, -- seconds to wait for response ext_app_name IN VARCHAR2 DEFAULT NULL, -- external app name for token generation ext_app_username IN VARCHAR2 DEFAULT NULL, -- external app username for token generation token IN VARCHAR2 DEFAULT NULL, -- token to use to send the request response OUT VARCHAR2); -- post job request response

TBD

POST_JOB_STATUS (new 21c)

Post a job status message pod_cdb_admin_http.post_job_status( url IN VARCHAR2, -- URL to receive the message job_id IN VARCHAR2, payload IN VARCHAR2, -- undocumented request_id IN VARCHAR2 DEFAULT NULL, token IN VARCHAR2 DEFAULT NULL, -- token to use to send the request response OUT CLOB); -- post job status

TBD