Hi all,

I am new on this list.

My problem is: My script to create and populate a new DB runs fine in WISQL, but executed by TIB_Script there is a problem with this statement:

execute procedure NewKoerperschaftKategorie 'OpenSource Team';

The error I get is (translated from OnError parameters):

ErrorCode: 335544358
SQLCode: -901

ErrorMessage:
ISC Fehlernummer:335544358
ISC Fehlermeldung:
message length error (encountered 0, expected 8)
STATEMENT:
TIB_DSQL: "<TIB_Script>.<TIB_DSQL>."

ErrorCodes:
335544358
4

SQLMessage:
SQL Fehlernummer:-901
SQL Fehlermeldung:
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements

SQL:
/* Master login inserts: */
/* ********************* */
execute procedure NewKoerperschaftKategorie 'OpenSource Team'



Three questions:

A. What can cause this incompatibility WISQL <-> TIB_Script ?
B. How to call this procedure correctly in IBO? Is it possible?
C. The procedure has a _result value_ (the ID of the new Lookup-Entry) which is ignored in my script I tried to make a test scenario with no result declaration -> this seems to work in IBO script. If this is the real problem, how can I declare global variables in a script to receive result values?


TIA

Heri Bender



IBO 4.2.Fr / WISQL 5.5 / D5 Pro


[Non-text portions of this message have been removed]