Re: Parameters for Stored Procedures? Oracle Versions?

A VB collection works like collections in C/C++ and Java in that it is an object that keeps a list of other objects that can then be referenced via the collection object, usually by index and also by a unique key. I'm assuming the VBA collection is just like the VB collection. VB interfaces to Oracle via ODBC, so my guess is that you are going to have to pull the items out of the collection and put them into the correct place in the parameter list in the call to the stored proc. Maybe someone has an ODBC interface that will deal with collections directly, but if so it is more likely to come from MS rather than from Oracle.

Rich Mycroft

"Thomas J. Kyte" <tkyte_at_us.oracle.com> wrote in message news:8i8j4o$9a2$1_at_nnrp1.deja.com...
> In article <39478DF0.42A8DE4D_at_gate.net>,
> "Keith L. Norris" <kln_at_gate.net> wrote:
> > Is there a limit on the number of parameters a stored procedure will
> > except?
>
> no, i've done hundreds and have tested upto 1,000.
>
> > Can an Oracle stored procedure except a VBA Collection as a
> > parameter and then break the collection up into its seperate items and
> > work with them individually?
> > Would this be available in Oracle8?
>
> don't know what a vba collection is....
>
> > How
> > long has Oracle8i been around and what are the significant differences
> > between Oracle8 and Oracle8i?
> >
>
> Oracle8i was released last summer.
>
> See
> http://technet.oracle.com/doc/oracle8i_816/server.816/a76962/toc.htm
>
> for a document that details the diffs between the releases.
>
> > Thank you very much,
> > Keith
> >
> >
>
> --
> Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
> Howtos and such: http://osi.oracle.com/~tkyte/index.html
> Oracle Magazine: http://www.oracle.com/oramag
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Jun 16 2000 - 00:00:00 CDT