Passing pl/sql table as parameter problems

From: Hervé Ferreira <admiral_freebee_at_hotmail.com>
Date: 12 May 2003 01:17:10 -0700
Message-ID: <ca41e26c.0305120017.15230f6c@posting.google.com>

Hi,

I've written a procedure that returns a pl/sql table as an outputparameter. In the procedure in which I call this procedure I want to store the table in a local pl/sql table. But I keep getting the following compilation error:

'Compilation errors for PACKAGE BODY EVAP.PCK_208E2_TEST

Error: PLS-00306: wrong number or types of arguments in call to

procedure 'BAR_LEEFTIJD'.
Line: 130
Text: PCK_208E2_BAREMA.bar_leeftijd(P_BAR_CODE => baremac, P_AANTAL_UREN => to_number(t_type_uur), P_DTVAN => v_datum, P_DTTOT => ttot, P_BAR_KLASSE_CODE => klassecode, P_TYPE_LOON => typel, P_LEEFTIJD => leeftijd,'

Originally I thought the problem was a type mismatch between the local pl/sql table and the type of the one I return from the procedure, but that doesn't seem to be the case.

any suggestions would be very welcome. Received on Mon May 12 2003 - 03:17:10 CDT