I am trying to execute a simple stored procedure for which I am receiving an isc_dsql_prepare failed message. The procedure code and error message are below. I am using Firebird 2.1 (classic) on Windows Vista. I have received the error using Flamerobin as well as using isql.

ALTER PROCEDURE POPULATE_UF20_CB1
Returns (STAFFID integer, STAFFNAME CHAR(30))
AS
BEGIN
SELECT STAFF_ID, STAFF_NAME
FROM LIST_STAFF
INTO :STAFFID, :STAFFNAME
SUSPEND;

END
*** IBPP::SQLException ***
Context: Statement::Prepare(
ALTER PROCEDURE POPULATE_UF20_CB1
Returns (STAFFID integer, STAFFNAME CHAR(30))
AS
BEGIN
SELECT STAFF_ID, STAFF_NAME
FROM LIST_STAFF
INTO :STAFFID, :STAFFNAME
SUSPEND;

END )
Message: isc_dsql_prepare failed

SQL Message : -104
Invalid token

Engine Code : 335544569
Engine Message :
Dynamic SQL Error
SQL error code = -104
Token unknown - line 9, column 1
SUSPEND

Thanks,
Ayreann