Subject | "Unknown token" error on semicolon on FB1.5.1 |
---|---|
Author | kernramp |
Post date | 2004-08-10T07:51:32Z |
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..
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..