PL/SQL (MOSC)

MOSC Banner

How to run a Form from a stored procedure within the DB.

edited Oct 11, 2011 1:44AM in PL/SQL (MOSC) 6 commentsAnswered
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);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center