Re: Variable parameter count for STPs?

From: Spencer <spencerp_at_swbell.net>
Date: Mon, 29 Jan 2001 20:21:02 -0600
Message-ID: <eypd6.168$kq4.127168@nnrp2.sbc.net>

in short, no, the number and datatypes of the arguments of a stored procedure are fixed. it is possible, however, to allow some of the arguments to be unspecified by using a DEFAULT value when it is omitted.

CREATE OR REPLACE PROCEDURE foo

(arg1    IN mytable.col1%TYPE DEFAULT NULL
,arg2    IN mytable.col2%TYPE DEFAULT NULL
,arg3    IN mytable.col3%TYPE DEFAULT NULL

) ...

the procedure can be called using either named argument or positional notation, depending on which arguments you need to leave unspecified.

"Christoph Kiehl" <ckiehl_at_kabel.de> wrote in message news:94pana$e1h$1_at_kilbeggan.xlink.net...
> Hi all,
>
> is it possible to have a variable number of arguments for a STP? I want to
> write an update procedure and pass only the fields that should be updated.
> The procedure should then decide which tables to update.
>
> Regards
> Christoph
>
>
>
Received on Mon Jan 29 2001 - 20:21:02 CST