> 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.

...

> 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)
> AS

...

> Execute procedure GET_SACS_BY_NO :UQSACSNO;

You forgot to specify RETURNING_VALUES clause.
But are you sure you want to use that procedure as executable instead of selectable ?

Ivan