Re: Passing parameters to stored procedure

Hi,

do it as Oracle does it in webdb - 2 pl/sql-Tables as parameter, one for the variable names, the other for the variable values

Klaus
"Joel Racicot" <j_racicot_at_hotmail.com> schrieb im Newsbeitrag news:398C00E9.6DC7E7FA_at_hotmail.com...
> Hi all again!
>
> I am working on a stored procedure that receives a variable number of
> parameteres from one transaction to another, via a web page. A table is
> updated based on the parameters passed to the stored procedure. My
> question is how would I go about coding this in the stored procedure?
>
> The number of parameters being passed ranges from 2 to 200 depending on
> the actions being performed on the web page. The obvious but tedious
> and code-intensive way is to declare 200 parameters as default null and
> check for not null. However, this would result in an inordinate amount
> of processing.
>
> Thanks for all your help as usual.
>
> Joel
>
Received on Sat Aug 05 2000 - 00:00:00 CEST