I´m working on a Java Application, in which I connect to an Interbase
Database (Version 6) via JDBC-Driver and pass orders to the database
by statement.execute(). Everything works fine, but when I want to send
a stored procedure to the database I get the following error:
interbase.interclient.SQLException: [interclient][interbase] Dynamic
SQL Error
SQL error code = -104
Token unknown - line 1, char 4
term
at interbase.interclient.RecvMessage.createSQLException(Unknown
Source)
at interbase.interclient.RecvMessage.makeSQLException(Unknown Source)
at interbase.interclient.RecvMessage.get_EXCEPTIONS(Unknown Source)
at interbase.interclient.Statement.remote_EXECUTE_STATEMENT(Unknown
Source)
at interbase.interclient.Statement.execute(Unknown Source)
[...]
The procedure begins with:
set term ^;
When I execute the statement via IBConsole or isql everything works as
expected.
Can anybody offer a solution for this problem?
Kind regards,
Jörg Fröber