Subject | TIB_Script and stored procedures |
---|---|
Author | Daniel Albuschat |
Post date | 2005-03-07T13:38:03Z |
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
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