Advanced SQL Tutorial - Oracle PL/SQL Code for Currency Conversion with Live Exchange Rates Data API

An Advanced SQL Tutorial - Oracle PL/SQL
In this lecture, I’ll show you how to make an HTTP connection request from a database and consume or call web service from Oracle SQL and PL/SQL queries.
The tutorial's SQL or PL/SQL code example shows a currency conversion using the latest/live foreign exchange rates from APILayer.com exchange rates data API.
For demonstration, the salary column of the employees' table of HR account shall be converted.
#consumingwebservice
#sqltutorial
#sqladvancedtutorial
#callingwebservicefromdatabase
#callingwebservicefromsql
#oracletutorial
#sqlcurrencyconversionquery
#utl_http
You may encounter flowing errors. You are welcome to ask me in the comments.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP
29273. 00000 - "HTTP request failed"
*Cause: The UTL_HTTP package failed to execute the HTTP request.
*Action: Use get_detailed_sqlerrm to check the detailed error message.
ORA-24247: network access denied by access control list (ACL)
ORA-28845: No certificate
ORA-29024: Certificate validation failure
ORA-28759: failure to open file
ORA-29106: Cannot import PKCS #12 wallet.
Facebook Tutorials Collection
/ oracle.tutorials
Oracle SQL or PL/SQL source Code
/ 1735747720153084
Please subscribe to my channel!

[@akmalabadillah3872]

Thx, it work on me..