Hi,

> SELECT COUNT (*) FROM CASSADD
> INTO TotCount;

<...snip...>

> SET TERM ## ;
> CREATE PROCEDURE GENERATECASSCERTIFICATIONDATA
> RETURNS (TotCount INT) <--------------------------

SELECT COUNT (*) FROM CASSADD INTO :TotCount;


<...>


Don't forget the colon !

Regards,
Arno