password : Developer123
workspace : yearlate
Project name :API Call
Sir please check using the above credentials .. and tell me what the issue i am doing as soon as possible
Sir here i have to display the name according to the code .. what should i do ? i can able to call the api … but i need the value of Sname from the API according to this Code which i am giving in the 1st field ..
DECLARE
l_data CLOB;
sName VARCHAR2 (50);
l_url VARCHAR2 (1000) :=
'http://webservices.oorsprong.org/websamples.countryinfo/CountryInfoService.wso/ListOfContinentsByCode/JSON/debug?''';
BEGIN
l_data := apex_web_service.make_rest_request(
p_url => l_url,
p_http_method => 'GET'
);
WITH json_tab AS
(
SELECT l_data FROM dual
)
SELECT sName
INTO :P2_NAME
FROM json_tab;
EXCEPTION WHEN no_data_found THEN
:P2_NAME := '';
END;
If i give a code like this … it won't displaying the value of sName … what should i do to get the value of sName in the :P2_name field according to sCode…
