Re: Parameters for Stored Procedures? Oracle Versions?

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.