0

My database is 19c ATP and I want to call a Rest API using PLSQL using Apex_Web_Service or UTL_Http but struggling to understand how to do so.

Below is the URL I am successfully able to call with Postman and can see the response but the same is not working well in PLSQL.

https://ta38.ocs.oraclecloud.com/test2/wms/lgfapi/v10/entity/inventory_history?company_id__code=INFOSYS&facility_id__code=NCO&history_activity_id=17&status_id=90 Maybe I am calling it incorrectly so requesting you to help me call the above correctly in PLSQL.

It always asks the value of facility_id__code as it has "&" sign in the URL.

DECLARE
  p_content CLOB;
BEGIN
  p_content := apex_web_service.make_rest_request (
           p_url         => 'https://ta38.wms.ocs.oraclecloud.com/cummins_test2/wms/lgfapi/v10/entity/inventory_history?company_id__code=CUMMINS&facility_id__code=NCO&history_activity_id=17&status_id=90'
         , p_http_method => 'GET'
         , p_username  => 'TEST'
         , p_password  => 'WELCOME'
        ) ;
END;
OldProgrammer
  • 12,050
  • 4
  • 24
  • 45
user3436905
  • 5
  • 2
  • Does this answer your question? [How do I ignore ampersands in a SQL script running from SQL Plus?](https://stackoverflow.com/questions/118190/how-do-i-ignore-ampersands-in-a-sql-script-running-from-sql-plus) – OldProgrammer Sep 14 '22 at 15:32

0 Answers0