Hi,
I need a function that from within Oracle Database calls an API to get the current currency rate from fixer.io. Code is written in PL/SQL
API Access Key is provided.
This is the example code prvided from [login to view URL] to do the job in PHP:
<?php
// set API Endpoint and API key
// Initialize CURL:
$ch = curl_init('[login to view URL]');
curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
// Store the data:
$json = curl_exec($ch);
curl_close($ch);
// Decode JSON response:
$exchangeRates = json_decode($json, true);
// Access the exchange rate values, e.g. GBP:
echo $exchangeRates['rates']['GBP'];
?>
Hi, I am 5 years experienced web developer expert in . I understand your point.
I can complete this project within 8 hours .
Please check my profile for my work quality .
Thanks,
Bhaskar Mandal
Hello,
I am Oracle certified professional and work as Oracle techno-functional consultant. I have done similar works before and I am ready to help you.
Please provide more details, thank you.
Hello,
Myself Barduga, I have 10+ years of experience in Oracle PLSQL and have extensively worked on Oracle. I can complete this task for you.
Please feel free to contact me.
Warm Regards
Barduga
Hi!
I have good experience in PL SQL, creating procedures that requests Web services, or call http/ftp, using utl_http and other internal funtions.
Be free to ask me,
Szb
You will need the ability to create an access control list and have been granted execute on utl_http. If you have those it shouldn’t Take me more than a day to build it.
Relevant Skills and Experience
I am a full time oracle developer. I have built 3 web api calls in the Oracle DB in the last 3 months.
Hi,
I did this before many times, directly from PLSQL or by java stored procedure. I have two questions please.
What is the version of Oracle Database?
Are you planning to use https protocol?
Regards,
Having 7+yrs of experience in developing business applications using Oracle PLSQL.
Got Top Talent Reward Consequently from last two years in the current organization.
Relevant Skills and Experience
Use to write subroutines(procedures/functions) regularly.
Having good PLSQL exposure writing of functions,procedures ,API's invoked from PLSQL using
I can able to deliver the code within 1 code with 19 EUR cost
sample code attached venkat reddy
create or replace function callapi( cmd in varchar2 )
return number
as
status number;
begin
dbms_pipe.pack_message( cmd );
status := dbms_pipe.send_message( 'HOST_PIPE' );
return status;
end;
/
Hello, My name is Ysmael. I've been working with Oracle databases for 8 Years.
I have already done some procedures to obtain the current exchange currency from different banks such as Costa Rica and Venezuela.
