Re: Adding a New Parameter to Stored Procedure

From: Stewart Burnett <Stewart_at_burnettms.nospam.demon.co.uk>
Date: Wed, 23 Dec 1998 17:00:27 -0000
Message-ID: <75r7jc$g42$1@hagen.cloud9.co.uk>

Use DEFAULT NULL thus;

create or replace procedure my_proc(param1 varchar2,param2 varchar2,param3 number, param4 date default null) IS

Frank Siegel <NorthernSnow_at_worldnet.att.net> wrote in message news:75r46o$4q9_at_bgtnsc03.worldnet.att.net...
>Hello,
>
>I want to add a new (the 4th) Parameter to a Stored Procedure.
>"easy!"
>
>
>But we already have hundreds of calls to this proc and we
>dont want to update them all. Can we make the 4th parameter
>optional. If so, what is the syntax?
>
>Thank You!
>Frank S.
>
>
>
Received on Wed Dec 23 1998 - 11:00:27 CST