Skip to main content
Question

Are you using UTL_HTTP in PL/SQL to call external REST API's


krestensb
Sidekick (Customer)
Forum|alt.badge.img+8

Hi,

Are you using PL/SQL to send dato to external REST API ?

Will you share your experience with that?

 

BR Kresten

4 replies

Mathias Dahl
Superhero (Employee)
Forum|alt.badge.img+32
  • Superhero (Employee)
  • 2822 replies
  • May 19, 2020

I have used it for posting data to external map services in ArcGIS. Works nicely. It is trickier if you need to handle some advanced authentication methods (especially if you need to support SSL/TLS, where you need to start to mess with wallets in Oracle) but, as always, Google is your friend :) You should ask your DBA or IT guys how they look at having outbound calls done by Oracle though…

We also use it in production in IFS, for archiving media library items to Azure Blob Storage. If we can do that, everything can be done with it…

 


Novacura_jst
Hero (Partner)
Forum|alt.badge.img+7
  • Hero (Partner)
  • 49 replies
  • May 30, 2020

I have used it for some RMBs to call some REST APIs for Novacura Flow and it works fine. Starting from Apps10 UP6 you could also call the new IFS event functionality Command_sys.Send_rest_message and not have to do the whole setup for utl_hhttp. I prefered the second option if available to you. Attached a few code samples i documented at that time (not very detailed explaination though).


Forum|alt.badge.img+1
  • Do Gooder (Customer)
  • 1 reply
  • June 10, 2020

If you are trying to use mTLS don’t bother!, read the following https://www.linkedin.com/pulse/take-rest-from-ifs-grant-hook

 


Anushka Rathnasiri
Do Gooder (Customer)
Forum|alt.badge.img
Mathias Dahl wrote:

I have used it for posting data to external map services in ArcGIS. Works nicely. It is trickier if you need to handle some advanced authentication methods (especially if you need to support SSL/TLS, where you need to start to mess with wallets in Oracle) but, as always, Google is your friend :) You should ask your DBA or IT guys how they look at having outbound calls done by Oracle though…

We also use it in production in IFS, for archiving media library items to Azure Blob Storage. If we can do that, everything can be done with it…

 

Can we read rest response?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings