wrong numer or types of arguments

From: Jan Haase <jh_at_informationsdesign.de>
Date: Wed, 25 Jul 2001 12:24:07 +0200
Message-ID: <3B5E9E47.5BDD47AA@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:24:07 CDT