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