Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Adding a New Parameter to Stored Procedure
tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>A copy of this was sent to "Frank Siegel" =
<NorthernSnow_at_worldnet.att.net>
>On 23 Dec 1998 16:02:32 GMT, you wrote:
>
>>Hello,
>>
>>I want to add a new (the 4th) Parameter to a Stored Procedure.
[...]
>>But we already have hundreds of calls to this proc and we
>>dont want to update them all.
[...]
>Default the new parameter and make sure it is the last parameter. Now a=
call
>like:
>
>exec your_procedure( 'a', 'b', 'c' )
>
>will still work. Default NEW_PARM to NULL or some hard coded value.
Thomas,
generally this used to work fine; however in conjunction with Forms 5.0
this gives a problem: everytime you modify a procedure or a package spec,
you must also recompile your Forms5 modules that call this procedure or
packaged procedure; otherwise Forms throws an exception 'ORA-4062:
timestamp of <your_procedure> has been changed'. AFAIK, this is an open =
bug
in Forms 5; it does not affect any stored PL/SQL that calls your =
procedure
with the modified parameter list (which will be valid again after
recompilation).
Merry Xmas and a great new year,
Peter
--
Peter Schneider
pschneider_at_knuut.de
Received on Wed Dec 23 1998 - 15:40:50 CST