Re: Pl/SQL - OUT Parameter Passing to OUT Parameter

Daigodai wrote:
> So I wrote proc_new to replace proc_old,
> (which has silly, non-sensical parameter name that's getting on my nerves)
>
> I have to leave proc_old's interface in place
>
> So both have identical interface, only differ in parameter names.
> Since parameters are all OUT...I want to ask you
>
> Do you think tthere is going to be a "problem" ?
> Anything anything wrong with this ?
> thx
> 10g
>
> --------------------------------------------------------
>
> PROCEDURE proc_new
> (p_1 OUT NUMBER,
> p_2 OUT NUMBER,
> p_3 OUT NUMBER)
> IS
> BEGIN
> *** code ****
> END proc_new;
>
> PROCEDURE proc_old
> (one OUT NUMBER,
> two OUT NUMBER,
> three OUT NUMBER)
> IS
> BEGIN
> proc_new (one, two, three) ;
> END proc_old;

The only problem I see is that your new names are just as devoid of meaning as your old ones. Is there a business rule against using parameter names that indicate the purpose of the parameter?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org