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!