Hi experts,
I’m trying to open a connection from an Oracle Database (12c) to Bonita 7.2.3 Community. ACL is correctly configured and tested.
Testing with SoapUI I get a 200 result and a jsessionid if user/pwd are correct, and a 500 error if don’t, so the service is ok.
I’m using package APEX_WEB_SERVICE, but I’m getting as result an HTML indicating “Unable to log in. Please check your username and password”.
This is my code. The status code I’m getting is a 200.
CREATE OR REPLACE PROCEDURE xx_test_rest3 AS
l_clob CLOB;
l_result VARCHAR2(32767);
BEGIN
apex_web_service.g_status_code := null;
l_clob := apex_web_service.make_rest_request(p_url => 'http://arostegui:8082/bonita/loginservice',
p_http_method => 'POST',
p_parm_name => apex_util.string_to_table('username:password:redirect'),
p_parm_value => apex_util.string_to_table('william.jobs:bpm:false'));
dbms_output.put_line('g_status_code='||apex_web_service.g_status_code);
dbms_output.put_line('l_clob=' || l_clob);
FOR i IN 1 .. apex_web_service.g_response_cookies.count LOOP
dbms_output.put_line('name =' || apex_web_service.g_response_cookies(i).name);
dbms_output.put_line('value =' || apex_web_service.g_response_cookies(i).value);
dbms_output.put_line('domain=' || apex_web_service.g_response_cookies(i).domain);
dbms_output.put_line('expire=' || apex_web_service.g_response_cookies(i).expire);
dbms_output.put_line('path =' || apex_web_service.g_response_cookies(i).path);
END LOOP;
dbms_output.put_line('l_result=' || l_result);
END;
Any ideas?
Regards,
Jose.