Hi,

> I'm using FB 1.5.3.4870
>
> When I try to compile the procedure code (displayed below), I get the
> following error message (caused by the Execute statement):
>
> fmCompile.trCompile:
> Invalid token.invalid request BLR at offset 454.
> parameter mismatch for procedure GET_SACS_BY_NO.

well, this gives it away, doesn't it?

> Any ideas what's wrong?

> /* ------------- procedure code ---------------- */
> CREATE PROCEDURE GET_SACS_BY_NO (
> PSACSNO INTEGER)
> RETURNS (
> ID INTEGER,
> UQSACSNO INTEGER,
> LITHONAME CHAR (60) CHARACTER SET WIN1252,
> LITHORANK CHAR (5) CHARACTER SET WIN1252)


> Execute procedure GET_SACS_BY_NO :UQSACSNO;

You're not accepting any return values.

Martijn Tonies
Database Workbench - development tool for Firebird and more!
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com