Re: Store Procedures with Parameters passing in - question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Wed, 25 Nov 1998 14:20:32 GMT
Message-ID: <365e11d5.3419386@192.86.155.100>

A copy of this was sent to joneveland_at_aol.com (Joneveland) (if that email address didn't require changing) On 25 Nov 1998 04:33:01 GMT, you wrote:

>>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).
>
>I thought ORACLE 7.x had a 255 limit , same as the number of fields on a
>table, and
>ORACLE 8.x was theoretically unlimited?
>
>Or did I disremember again?
>
>Jon Eveland

disremembering....

I just tested on 7.3:

create or replace procedure test_parms(

p_1 in number,
p_2 in number,
p_3 in number,
p_4 in number,
p_5 in number,
p_6 in number,

.....
p_499 in number,
p_500 in number )
as
begin
null;
end;
/

It created with 500 inputs. Then I ran:

variable v_1 number
exec :v_1 := 1
variable v_2 number
exec :v_2 := 1
variable v_3 number
exec :v_3 := 1
variable v_4 number
exec :v_4 := 1
....
variable v_499 number
exec :v_499 := 1
variable v_500 number
exec :v_500 := 1

to setup 500 bind variables in sqplus... Then lastly I ran:

begin
test_parms(

:v_1 ,
:v_2 ,
:v_3 ,
:v_4 ,
:v_5 ,
:v_6 ,

...

:v_498 ,
:v_499 ,
:v_500  ) ;

end;
/

and it worked...  

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 Wed Nov 25 1998 - 08:20:32 CST