Re: Max Number of Parameters in Oracle Stored Procedure

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Sat, 24 Oct 1998 13:17:47 GMT
Message-ID: <3631d31e.5595165@192.86.155.100>

A copy of this was sent to pax_at_webeasy.com (if that email address didn't require changing) On Sat, 24 Oct 1998 02:03:46 GMT, you wrote:

>Hi:
>
>What is the max number of parameters in an Oracle Stored Procedure ?
>
>Thanks
>Pax
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

There is no limit, I've done it with hundreds (3 or 4 hundred inputs) as a test and it works (but is not pratical -- a procedure with 3 or 4 hundred inputs? why?)  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/ -- downloadable utilities  

---

Opinions are mine and do not necessarily reflect those of Oracle Corporation  

Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Oct 24 1998 - 08:17:47 CDT