Re: Passing pl/sql table as parameter problems

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 12 May 2003 20:12:06 +0200
Message-ID: <suovbvstv46lf7jd6qsqcbmp0jiof2mr82@4ax.com>

On 12 May 2003 01:17:10 -0700, admiral_freebee_at_hotmail.com (Hervé Ferreira) wrote:

>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.
>

Without the formal declaration of bar_leeftijd there is nothing to work on.

>any suggestions would be very welcome.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 12 2003 - 13:12:06 CDT