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