firebird stored procedure

I am trying to create a basic stored procedure for Firebird and keep getting the following error:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 5, char 1.
end.

Here is my syntax for the create procedure:

SET TERM ^ ;

CREATE PROCEDURE GetFirstName
AS
begin
select FirstName from Addresses
end
^

SET TERM ; ^

I have tried everything and cannot avoid the error. I have the Dialect set to 3 should you need that information.

I would appreciate any feedback.

Jason

Try this

CREATE PROCEDURE GetFirstName
RETURNS (
FirstName VARCHAR(20))
AS
BEGIN
FOR SELECT FirstName
FROM Addresses
INTO :FirstName
DO
BEGIN
SUSPEND;
END
END

--
Best regards,
Fikret Hasovic http://fikret.fbtalk.net

FirebirdSQL Foundation member.
- Join today at http://www.firebirdsql.org/ff/foundation
JEDI VCS contributor
http://jedivcs.sourceforge.net/