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: Variable parameter count for STPs?

Re: Variable parameter count for STPs?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 25 Jan 2001 19:22:46 +0100
Message-ID: <94pt5j$ek7ts$6@ID-62141.news.dfncis.de>

It is possible. They should be trailing, and you should have a default clause like this
in_num in number default 0

etc.

Hth,

Sybrand Bakker, Oracle DBA

"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 Thu Jan 25 2001 - 12:22:46 CST

Original text of this message

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