Hi,
I'm trying to get data from a RESTful API (https server) using a PLSQL procedure developed in an Oracle DB (Oracle Database 19c EE Extreme Perf Release 19.0.0.0.0 - Production Version 19.23.0.0.0). I'm using SQL developer.
My problem is that the payload received in Oracle DB, using utl_http.read_text or utl_http.read_raw, is broken. Some payload elements are missing (doublecheck with POSTMAN call where the received payload is complete).
Rest API call header parameters are configured similar for both calls ( Postman and OracleDB).
Attached:
- Postman parameters
- Oracle DB call (NLS_CHARACTERSET AL32UTF8 )
- Response Postman
- Response DB – missing Contacts element
How could I identify which is the source problem for the broken payload received in Oracle DB?
How could I resolve this issue in order to receive in OracleDB the same payload as in Postman ( complete response from RestAPI)?
I've checked with DBA team and it seems that Oracle Patch from Document 2771011.1 (oracle.com). is already applied.
Best regards,
Daniela
DB_Call_API_oracle_comm.txt
Attach_Postman_OracleDB.docx