Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to call a parametrized procedure from a htp.formsubmit

711318Jul 10 2009 — edited Jul 10 2009
Hi there, i'm trying to call a procedure with parameters from my formsubmit. i would like to call that procedure once my submit button is pressed. I did this :

HTP.formOpen(twbkwbis.f_cgibin||'MyPackage.MyProcedure(param1, param2, param3, param4)');
twbkfrmt.P_PrintText('<input type=submit name=ACTION value="Soumettre">');
HTP.formClose;

but i had that 404 error page not found .

i also did this :

twbkfrmt.P_PrintText( htf.formSubmit(NULL, 'Soumettre', cattributes=>'ONCLICK= " return MyProcedure(param1, param2, param3, param4) " ') );

and still the same error...does anyone have an idea to help me with this...thank you

Edited by: user11146505 on 2009-07-10 06:49

Edited by: user11146505 on 2009-07-10 06:51

Edited by: user11146505 on 2009-07-10 06:52

Edited by: user11146505 on 2009-07-10 06:52

Edited by: user11146505 on 2009-07-10 06:54

Edited by: user11146505 on 2009-07-10 06:55

Edited by: user11146505 on 2009-07-10 06:55

Edited by: user11146505 on 2009-07-10 06:57
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 7 2009
Added on Jul 10 2009
3 comments
828 views