Syntax Errors in Stored Procedures
InterBase generates errors during parsing if there is incorrect syntax in a
CREATE PROCEDURE statement. Error messages look similar to this:
Statement failed, SQLCODE = -104 Dynamic SQL Error -SQL error code = -104 -Token unknown - line 4, char 9 -tmp
The line numbers are counted from the beginning of the
CREATE PROCEDURE statement, not from the beginning of the data definition file. Characters are counted from the left, and the unknown token indicated is either the source of the error, or immediately to the right of the source of the error. When in doubt, examine the entire line to determine the source of the syntax error.