Hi Buddies,
I have a ws request which has basic authentication set.
First, i tried without giving username & pwd. It gave me authorisation failed. (that means i am able to hit the target url succesfully).
WS_RESPONSE := APEX_WEB_SERVICE.MAKE_REST_REQUEST
(
p_url => <target url>,
p_http_method => 'POST',
p_body => '{ field1:value1 }',
p_wallet_path => <wallet_path>,
p_wallet_pwd => <wallet_pwd>
);
o/p :
i get html response beginning with : <TITLE>Error 401--Unauthorized</TITLE>
Next, I am giving both userrname & pwd. BUT now it throws ORA-29267: illegal call ERROR.
WS_RESPONSE := APEX_WEB_SERVICE.MAKE_REST_REQUEST
(
p_url => <target url>,
p_http_method => 'POST',
p_body => '{ field1:value1 }',
p_username => <username>,
p_password => <pwd>,
p_wallet_path => <wallet_path>,
p_wallet_pwd => <wallet_pwd>
);
o/p:
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1185
ORA-29267: illegal call
FYI : I am calling the API inside a stand alone procedure.
Kindly provide me some inputs on this.
Thanks,
Praveen