Hi,

> 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".

This should give you a hint :-)

select "displayname" into what? Where should the result go?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com