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>
Date: 8 Nov 2001 09:49:51 -0800
Message-ID: <8d71f979.0111080949.638e1efb_at_posting.google.com>
Hello all,
PROCEDURE remove(pid IN NUMBER);
In the package body, I want to do the following
PROCEDURE remove(pid IN NUMBER, pcounter IN OUT PLS_INTEGER) IS
BEGIN
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, pcounter IN OUT PLS_INTEGER);
..
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