Re: Arrays --- Retrieving from Oracle w/PL/SQL

heftym_at_mail.state.wi.us wrote:

>In my VB app I have several arrays that I need to fill to
>subsequently load many dropdown lists. Rather that filling
>these as they are needed I am creating arrays by sending one
>PL/SQL stored procedure call that in effect loads the data for
>many arrays all at once at the server level and passes it back
>to VB. I am passing the array items back as a comma-delimited
>list and then parsing the lists up and creating the actual arrays
>when I get back to VB. Since Oracle doesn't currently support
>passing arrays as parameters I don't know of a better way to do
>this. Do you?
 

> Thanks in advance,
> Mike
 

>=========================================
>Michael Hefty heftym_at_mail.state.wi.us
>5311 Manitowoc Pkwy
>Madision, WI 53705
>=========================================
Define table as output variable in pl/sql and for example in case of PB, I have defined as array. It works. If you can not emulate this technique, we can define output variable as long (in oracle) and populate it with comma seperated strings. In your VB applications, parse and form the list. Received on Sun Jan 28 1996 - 00:00:00 CET