Calling REST API From DAS PLSQL Code (Doc ID 2961010.1)

Last updated on JULY 13, 2023

Applies to:

Goal

When trying to call the REST API from PLSQL code in DAS Schema and getting below Error while calling utl_http.begin_request

Error: ORA-29272: HTTP request failed.

 
DESCRIBE HOW THE CURRENT PRODUCT FUNCTIONALITY IS INSUFFICIENT
==============================================================

Currently to check the count of messages stuck in RIHA by item cre or item updates, you have to query it directly on DDS schema without using PL/SQL code.

PROVIDE A DETAILED DESCRIPTION OF THE ENHANCEMENT REQUEST
=========================================================
The customer wants to use the UTL_HTTP utility to call REST API from PLSQL to generate a report to extract the count of messages stuck in RIHA by item create or item updates.

DBA confirmed that needs to be done by the development team as repeatable process to add this new functionality.

DESCRIBE HOW THIS ENHANCEMENT WILL BENEFIT YOUR BUSINESS
========================================================
Business need as stated by the customer: We need to generate a report to extract the count of messages stuck in RIHA by itemCre or item updates.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.