Re: passing parameters from HTML form to pl/sql procedure - this is a good question!

The OWA_TEXT package provides two datatypes: VC_ARRAY and INT_ARR, one-dimensional arrays with members of type varchar2(32000) and integer respectively, both indexed by binary integer in the traditional way that one addresses one-dimensional arrays. Use these datatypes for your multi-selects and you're all set, no need to initialize the arrays with upper bounds or anything like that (e.g. "my_array IN OWA_TEXT.VC_ARRAY" is all you need). I'm not sure, but I believe that these datatypes may ONLY work as input parameters sent from a POST action via the Oracle Web Server, so don't attempt to declare them elsewhere in your procedures.

NOTE: The documentation that comes with Oracle Web Server covers these items, but lists them as VC_ARRAY and INT_ARRAY. With some versions of the packages the datatypes are in reality called *_ARR instead of *_ARRAY. You'll have to see which ones work for your version of the web server.

I've used these dataypes many, many times to do exactly what you describe. Guaranteed, they do what you're looking for.

Good luck,
-Brendan

In article <3561DB7D.6CDB66D2_at_sqlsystems.dk>,   ajd_at_sqlsystems.dk wrote:
>
> Riddle me this Oracle people,
>
> I have a great problem. I want to be able to pass all the INPUT form
> values from an HTML form page to PL/SQL (vis OWA 2.1 or 3.x), such that
> they're all packed up in an 'array' - like when you pass multiple values
> of a list box. Can this be done?
>
> why do I ask this? because i'm sick and tired or writing pl/sql procs
> with gazillions of parameters - it's ugly and hard to manage!
>
> if you have an answer, write to me at ajd_at_sqlsystems.dk or just post
> your solution to the usenet, referencing this message. Thanks in
> advance,
>
> Alexander Day
> SQL Systems Danmark
> ajd_at_sqlsystems.dk
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Wed May 20 1998 - 07:01:59 CDT