> and parameter numbers start with ONE. I tested it too.

And on my PC parameters start with ZERO:

SET TERM ^;
CREATE PROCEDURE P AS
DECLARE VARIABLE tmp INTEGER;
BEGIN
EXECUTE STATEMENT 'SELECT 12.3 FROM RDB$DATABASE' INTO :tmp;
END^
SET TERM ;^

EXECUTE PROCEDURE P;
Statement failed, SQLCODE = -904

Variable type (position 0) in EXECUTE STATEMENT 'SELECT 12.3 FROM RDB$DATABASE'
INTO does not match returned column type


Ivan

----- Original Message -----
From: "Filipe Belchior" <filipe.belchior@...>
To: <firebird-support@yahoogroups.com>
Sent: Wednesday, July 14, 2004 12:24 AM
Subject: [firebird-support] Re: variable type does not match return


Hi ivan,

First, No! The two values are INTEGER.

and parameter numbers start with ONE. I tested it too.

but, thanks...

Belchior, Filipe.


--- In firebird-support@yahoogroups.com, "Ivan Prenosil"
<Ivan.Prenosil@s...> wrote:
> * perhaps difference between Integer and Bigint (int64) ?
> * parameter numbers start with zero ... (so "3" means fourth
parameter)
>
> Ivan
>
>
> ----- Original Message -----
> From: "Filipe Belchior" <filipe.belchior@m...>
> To: <firebird-support@yahoogroups.com>
> Sent: Monday, July 12, 2004 7:43 PM
> Subject: [firebird-support] variable type does not match return
>
>
> > > Hi,
> > >
> > > Exception in a Stored Procedure:
> > >
> > > variable type (position 3) in
> > > EXECUTE STATEMENT '... ...' INTO does not match return.
> > >
> > > But, in the FOR EXECUTE STATEMENT, the field in position 3 is
integer,
> > > and the Stored Procedure outputparameter is integer too.
> > > So I don´t understand!