Advice needed, PLS-00306 error

From: Alex Kogan <a-kogan_at_nwu.edu>
Date: Mon, 06 Aug 2001 22:45:57 -0500
Message-ID: <3B6F6475.81E79157@nwu.edu>

Oracle 8.1.6.

We have two packages.
Package 1 declares two types:

TYPE t_recNew_id IS RECORD (new_id new_response.nr_new_id%TYPE); TYPE t_idTable IS TABLE OF t_recNew INDEX BY BINARY_INTEGER;

Package 2 uses types from package 1 to supply arguments to procedures:

---

PROCEDURE subtotals_in_group (tblNewIds IN package_1.t_idTable) IS

nSub1_2 NUMBER;

BEGIN         nSub1_2:=subtotals_for_pair(tblNewIds(0).new_id,tblNewIds(1).new_id);                                         

END; PROCEDURE subtotals_for_pair (nNewId1 IN package_1.t_idTable.new_id%TYPE, nNewId2 IN package_1.t_idTable.new_id%TYPE) IS                  

BEGIN   ...

END;

---

Procedure subtotals_for pair doesn't compile. I get the following errors:

---

44/6 PL/SQL: Statement ignored
44/17 PLS-00306: wrong number or types of arguments in call to

'SUBTOTALS_FOR_PAIR'
45/6 PL/SQL: Statement ignored
45/17 PLS-00306: wrong number or types of arguments in call to

'SUBTOTALS_FOR_PAIR'

---

I'd be very grateful to anyone who'd explain what am I doing wrong.

Thank you, Alex. Received on Mon Aug 06 2001 - 22:45:57 CDT