Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Is there a limit to the number of parameters being passed to a stored procedure?

Re: Is there a limit to the number of parameters being passed to a stored procedure?

From: Thor HW <thor_at_Echidna.net>
Date: 1998/03/24
Message-ID: <6fa1ef$n0m$2@news.bctel.net>#1/1 







Yes there is. I believe that it is 32 or something fairly close in Oracle7.
You can use arrays (PL/SQL tables) if you are passing in similar items.



Thor HW


Cathal Bolster wrote in message


<01bd5753$ac4be900$40757dc2_at_test064.msc.ie>...


>Hi folks,

>

>anyone out there know if there's a limit to the number of parameters being

>passed to a stored procedure?

>

>Thx in adv.

>Cathal.

Received on Tue Mar 24 1998 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US