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

Published: 03 March 2023
on channel: The Oracle Professor

1,195

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!

On this page of the site you can watch the video online Advanced SQL Tutorial - Oracle PL/SQL Code for Currency Conversion with Live Exchange Rates Data API with a duration of hours minute second in good quality, which was uploaded by the user The Oracle Professor 03 March 2023, share the link with friends and acquaintances, this video has already been watched 1,195 times on youtube and it was liked by 15 viewers. Enjoy your viewing!