Re: OWS and PL/SQL

[Quoted] On Tue, 30 Jun 1998 21:08:17 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:

>A copy of this was sent to bubbaq_at_my-dejanews.com
>(if that email address didn't require changing)
>On Tue, 30 Jun 1998 17:57:28 GMT, you wrote:

>the plsql cartridge takes a URL like:
>
>http://hostname/dcdname/owa/some_procedure?z=5&x=10&a=Hello+World

        This looks like "GET" data. How does it handle "POST" data??

>And maps that to a database call like:
>
>begin
> some_procedure( a => :a, x => :x, z => :z );
>end;

[Quoted]         My form has 80+ fields. (Don't worry, about 75 of them are generated by a C program :) Do I really have to have an 80+ long parameter list?? I saw an earlier reply of yours about passing in parameters as a PL/SQL table. Since I have so many fields, this was the best option.

>OAS4.x will allow you to instead have the variables saved in a pair of arrays,
>sort of like an associative array, and have a procedure some_procedure that
>recieves these arrays instead of named formal parameters -- your procedure would
>get an array of names and an array of values passed to it.

[Quoted] Would this be simply 2 PL/SQL tables in the param list for my entry procedure??

Thanks again,
Jack Erwin
erwinja_at_mscd.edu

P.S.
[Quoted] Any plans for real associative arrays in PL/SQL? Received on Wed Jul 01 1998 - 09:15:38 CEST