Hi,
Are you using PL/SQL to send dato to external REST API ?
Will you share your experience with that?
BR Kresten
Are you using UTL_HTTP in PL/SQL to call external REST API's
Userlevel 3
+8
Userlevel 7
+30
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…
Userlevel 4
+7
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).
+1
If you are trying to use mTLS don’t bother!, read the following https://www.linkedin.com/pulse/take-rest-from-ifs-grant-hook
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
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.