At 08:56 AM 17/03/2009, Ayreann wrote:

>I am trying to execute a simple stored procedure

You do mean "trying to compile a simple stored procedure", right?

>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 <--- missing semicolon
>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

SUSPEND is an unknown token because the parser expects the semicolon terminator on the preceding statement.

./heLen