Re: Q: Help with PL/SQL tables with HTML forms and WEB server

From: Christopher Beck <clbeck_at_us.oracle.com>
Date: Wed, 22 Jul 1998 19:55:22 GMT
Message-ID: <35b64076.28049893@dcsun4.us.oracle.com>

On Wed, 22 Jul 1998 20:25:21 +0200, Adolfo Andrade
<aandradeg_at_mx3.redestb.es> wrote:

>Hi, all
>
>Does anybody knows how to use PL/SQL tables passed as parameters to
>procedures called from HTML forms in the Web?

sure.

Consider

<HTML>
<FORM action="myProc">

1.
<INPUT TYPE=TEXT NAME=T>
<BR>

2.
<INPUT TYPE=TEXT NAME=T>
<BR>

3.
<INPUT TYPE=TEXT NAME=T>
<BR>

4.
<INPUT TYPE=TEXT NAME=T>
<BR>
<INPUT TYPE=SUBMIT>
</FORM>
</HTML>

and

procedure myProc( T owa.vc_arr ) is
begin
for i in 1 .. T.count loop
htp.p( i || '. ' || T(i) );

    htp.br;
  end loop;
end myProc;

myProc will produce a page containing the four values supplied in the previous form.

When T comes into the myProc procedure it will have values in indexes 1 .. 4, though they might be null if the user of the HTML form did not supply a value in the textbox. Use T just like any other PL/SQL table.

>Is there any doc.?

Check the PL/SQL users guide for more info.

Hope this helps.

chris.

>
>Thanks in advance,
>ADOLFO

Received on Wed Jul 22 1998 - 14:55:22 CDT