Oracle | POD_CDB_ADMIN

Oracle POD_CDB_ADMIN_HTTP 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 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