Re: wrong numer or types of arguments

Hello!

Try initialize variable rotation (and may be referenz too). Somthing like this:
 rotation RotationTableType:=RotationTableType(1);

Yaroslav.

Jan Haase <jh_at_informationsdesign.de> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:3B5E9E47.5BDD47AA_at_informationsdesign.de...
> Hi.
>
> I didn't find a newsgroup regarding pl/sql, so I write here:
>
> I want to use a function "sam" in a package "sammler":
> errorcode := sammler.sam(registration, rotation, referenz);
>
> The problem is, I always get "PLS-00306: wrong number or types of
 arguments in
> call to 'SAM'" -
> but I don't see why the arguments may be wrong.
>
>
> The function call is used in a pl/sql script:
>
> --
> declare
> TYPE RotationType IS RECORD
> (reg varchar2(12), status varchar2(1) );
> type RotationTableType is varray(1000) of RotationType;
> TYPE ReferenzType IS RECORD
> ( tail_nr varchar2(12), counter_ind varchar2(1));
> registration varchar2(12) := 'DABEA';
> rotation RotationTableType;
> referenz ReferenzType;
> errorcode number := 0;
> begin
> errorcode := sammler.sam(registration, rotation, referenz);
> end;
> --
>
> The package "sammler" compiles without problems (head and body) and the
> contained function "sam" has the following head:
> FUNCTION Sam
> ( registration IN VARCHAR2,
> rotation OUT RotationTableType,
> referenz OUT ReferenzType
> ) return number;
>
> The type definitions used in the package are identical to those used in
 the
> pl/sql script above.
>
>
> Any ideas or useful hints?
> Thanks in advance,
>
> Jan
>
>
>
>
Received on Wed Jul 25 2001 - 05:39:11 CDT