Re: passing arrays to a Oracle Stored Procedure

Think REF CURSOR or CLOB.

Daniel Morgan

anon wrote:

> I have looked around the internet and did not find any good examples. I do
> have a VB book, but the pl/sql side was what I was not sure about.
> Thank you for the info I will keep looking now that I know that it is
> possible.
>
> "Mark D Powell" <mark.powell_at_eds.com> wrote in message
> news:178d2795.0202180750.46ace4b9_at_posting.google.com...
> > "Tim Savage" <tim.savage_at_verizon.net> wrote in message
> news:<AzVb8.2192$xG4.457043_at_paloalto-snr1.gtei.net>...
> > > I am writing a application in ASP using oracle as the DB. I was to send
> the
> > > info from the invoice to the DB via an array because there is a lot of
> data.
> > > How would I go about sending the code to the oracle DB? Is it possible
> to
> > > send an array to an oracle stored proc?
> > >
> > > Thank you
> > > Tim Savage
> >
> > Tim, the answer is yes. In the pl/sql procedure you code the
> > parameter to expect a pl/sql table, which is really equilivent to a
> > single dimension array. You should be able to find examples of
> > defining and using a pl/sql table in the pl/sql manual. I am not sure
> > what you do on the VB end, but I believe you just code an array.
> >
> > The developer I know did this here had a VB book with an example that
> > said he had to create on plsql table for each column being passed as
> > VB could not handle Oracle composite datatypes; however, I have heard
> > that the newer versions of VB can pass composite so it should be
> > possilbe to pass an array of records, but you will probably need to
> > find a good VB book with an example.
> >
> > Unless another poster has the time to post you an example you might
> > want to try visiting the nearest book superstore (Barnes and Noble,
> > Borders) and look over their VB books. I have found an outside
> > library to be very valuable for examples like this.
> >
> > -- Mark D Powell --
Received on Wed Feb 20 2002 - 16:49:31 CST