Hi All,
I have a requirement to call a webservice ( apex to oracle fusion) , i have created dynamic action and the event is execute is pl sql code and below is my sample code
declare
l_clob CLOB;
p_url VARCHAR2 (1000);
BEGIN
apex_web_service.g_request_headers(1).name := 'Content-Type';
apex_web_service.g_request_headers(1).value := 'application/x-www-form-urlencoded';
p_url := CONCAT ('Oracle Fusion URL', 'mywork');
l_clob := apex_web_service.make_rest_request(
p_url => p_url,
p_username => 'username',
p_password => 'pwd',
p_http_method => 'POST',
p_wallet_path => 'walletpath',
p_wallet_pwd => 'walletpwd',
p_parm_name => apex_util.string_to_table('Id'),
p_parm_value => apex_util.string_to_table('12345'));
END;
when i click on submit button , i am calling this action but i am getting the below error
Ajax call returned server error ORA-29273: HTTP request failed for Execute PL/SQL Code.
Please let me know what i have missed here.
Regards,
San