Overloading procedures

From: Vince <vopipari_at_ehealthcontracts.com>
Date: 8 Nov 2001 09:49:51 -0800
Message-ID: <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 - 18:49:51 CET

Original text of this message