Re: Store Procedures with Parameters passing in - question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 25 Nov 1998 00:33:36 GMT
Message-ID: <365e501f.3606055@192.86.155.100>

A copy of this was sent to Jason Ladew <jal_at_esc188.expansion.com> (if that email address didn't require changing) On Tue, 24 Nov 1998 12:37:53 -0800, you wrote:

>Hello,
>
>Hopefully this is really simple. What is the max number out allowable
>parameters that can be passed into a stored procedure? I've looked in a
>couple of books and they either say nothing regarding this and another
>book "infers" that there is no limit, but it is a matter of
>managability.
>
>Is there a fixed limit.
>

there is no fixed limit, I myself have done hundreds. It is a matter of managability (you'll find binding hundreds of inputs pretty painful after a while)...

>Thanks,
>
>Jasonl
>
 

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 Tue Nov 24 1998 - 18:33:36 CST