Hi, I think the WorkBench error is sensible. Why/How to select
something without putting it anywhere. Do as the message tells you and
change to 'select DisplayName from QuestionCategory into :myvariable;'

Set

--- In firebird-support@yahoogroups.com, "kernramp" wrote:
> When I try to create a stored procedure:
> CREATE PROCEDURE mysp as
> begin
> select DisplayName from QuestionCategory;
> end
> where both table and field exist, I get an error:
> Dynamic SQL Error
> Dynamic SQL Error
> SQL error code = -104
> Token unknown - line 3, char 25
> ;
> This happens on FB1.5.1 on Windows, through ODBC and SQL Explorer
> (Delphi 5 version). This problem also shows when connecting with
ODBC
> to a Linux server version.
>
> In Database WorkBench, I tried to create a stored procedure through
> the interface:
> SET TERM ^^ ;
> CREATE PROCEDURE P_
> AS
> begin
> select DisplayName from QuestionCategory;
> end
> ^^
> SET TERM ; ^^
> and I get the following error:
> "into expected but ; found". Previously, creating other stored
> procedures within the same database did work. I don't know if any of
> the metadata was damaged or anything; at the moment I'm all out of
> options and wondering if anyone has seen this error before..