Re: Overloading procedures

You'll have to pass a variable into it, even if it only contains a default or dummy value

PROCEDURE remove(p_id IN NUMBER) IS

   v_counter NUMBER := 0;
BEGIN
   remove(pid, v_counter);
END remove;

Mark

vopipari_at_ehealthcontracts.com (Vince) wrote in message news:<8d71f979.0111080949.638e1efb_at_posting.google.com>...
> Hello all,
> I am not new to PL/SQL programming, but have never overloaded
> procedures.
> What I would like to do is have 2 possibilities:
>
> PROCEDURE remove(pid IN NUMBER);
> PROCEDURE remove(pid IN NUMBER, pcounter IN OUT PLS_INTEGER);
>
> In the package body, I want to do the following
>
> PROCEDURE remove(pid IN NUMBER, pcounter IN OUT PLS_INTEGER) IS
> BEGIN
> ..
> END;
>
> PROCEDURE remove(p_id IN NUMBER) IS
> BEGIN
> remove(pid, 0);
> END remove;
>
> When I do this, I receive PLS-00363 expression '0' cannot be used as a
> target assignment.
>
> Do I have to create a third procedure within the package body that
> both remove procedures call?
>
> Any help on this would be greatly appreciated.
Received on Fri Nov 09 2001 - 09:30:00 CET