Subject TIB_Script and stored procedures
Author Daniel Albuschat
Hello,

TIB_Script seems to be "incompatible" with stored procedures
called by an "execute procedure" statement.
It gives the error


ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 2, char 1
execute

which seems to be a database error.
The same code works for a TIB_DSQL or in isql without
any problems, though.

You can test this with, for example, IBOConsole, which
seems to use the TIB_Script component in the
"Interactive SQL" dialog.
When you try to execute the statement
"execute procedure some_proc"
it gives the error mentioned above.

Does the TIB_Script component parse and modify
the "execute procedure" statement in some way, and
maybe break it somehow?
Btw., the procedure is executed anyways. It just gives
this error message/exception.

regards,
Daniel

--
eat(this); // delicious suicide