Syntax Errors in Stored Procedures

Go Up to Procedure and Trigger Language

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.