Re: Overloading procedures

You cannot pass a constant through an IN/OUT parameter. You have to use a variable.

"Vince" <vopipari_at_ehealthcontracts.com> 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 Thu Nov 08 2001 - 20:49:31 CET