How to run a Form from a stored procedure within the DB.
Hi everyone.
Can I execute a Form from a stored procedure within the DB?
The DB version is 10.2.0.4.0 and the form is builder in DevSuite 10.
I've tried with the following anonymous block:
DECLARE
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
p_url varchar2(1000);
v_value varchar2(32000);
BEGIN
p_url :='http://brsmmsa0gmao11.laam.corp.gm.com/forms/frmservlet?form=D:\Appl\gma\GBS\10770-LPDR\LPDR\prueba.fmx'|| chr(38) ||'otherparams=cantidad=2'';
l_http_request := UTL_HTTP.begin_request(p_url);
l_http_response := UTL_HTTP.get_response(l_http_request);
UTL_HTTP.end_response(l_http_response);
Can I execute a Form from a stored procedure within the DB?
The DB version is 10.2.0.4.0 and the form is builder in DevSuite 10.
I've tried with the following anonymous block:
DECLARE
l_http_request UTL_HTTP.req;
l_http_response UTL_HTTP.resp;
p_url varchar2(1000);
v_value varchar2(32000);
BEGIN
p_url :='http://brsmmsa0gmao11.laam.corp.gm.com/forms/frmservlet?form=D:\Appl\gma\GBS\10770-LPDR\LPDR\prueba.fmx'|| chr(38) ||'otherparams=cantidad=2'';
l_http_request := UTL_HTTP.begin_request(p_url);
l_http_response := UTL_HTTP.get_response(l_http_request);
UTL_HTTP.end_response(l_http_response);
0