| Subject | Re: [ib-support] Another Question on SP |
|---|---|
| Author | R. Tulloch |
| Post date | 2002-06-10T11:27:59Z |
Arno Brinkman wrote:
>Doesn't work with colon there.
> 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 !