> Hi all
>
> Thanks to Helen help in another thread I am onto writing SPs
> in FireBird. Unfortunately my simplest of SP does not return
> any value when I execute it as follows: SELECT * FROM NarrAcctOpBal
>
> The SP is as follows:
> SET TERM ^ ;
> CREATE PROCEDURE NARRACCTOPBAL
> RETURNS (
> MNARRATION Varchar(32000) )
> AS
> BEGIN
> mNarration = 'Opening Balance';

> END^
> SET TERM ; ^
>
> Please advise on what I need to do more. Down the line I
> will have a parameter to this SP which provides an PK that
> needs to be looked up. I intend to do a SELECT and create a
> string using the PK parameter in the WHERE and return this
> string to be used in my other SELECTs.
>
> Thanks and regards
> Bhavbhuti