Subject Re: [firebird-support] Output Parameter
Author Ivan Prenosil
> I am using Firebird 2.0. I have this stored procedure:
>
> CREATE PROCEDURE SERIALY (
> SCHL Varchar(5),
> YAR Varchar(4) )
> RETURNS (
> VAL Smallint )
> AS
> ...
>
> I have keep getting error on EXECUTE PROCEDURE serialy ('0404','2007') RETURNING_VALUES (:VAL). The error message is
>
> Engine Code : 335544569
> Engine Message :
> Dynamic SQL Error
> SQL error code = -104
> Token unknown
> RETURNING_VALUES

Drop RETURNING_VALUES, this clause is only used when you execute the procedure
from within another procedure.

Ivan
http://www.volny.cz/iprenosil/interbase/