I'm just starting with MB, so it might be a dumb question, but I cannot find a similar problem in the web.
I've an Oracle XE installation and a simple table:
CREATE TABLE SP_SCHEDULER
ID NUMBER(10, 0) NOT NULL,
ACTIVE VARCHAR2 (1) DEFAULT 'F',
Insert into SP_SCHEDULER (ID, ACTIVE ) values ( 99931, 'T' ) ;
I want to do a select via PASSTHRU in ESQL:
SET OutputLocalEnvironment.SQLTrigger =
PASSTHRU('SELECT ROWID, SQL_STATEMENT_ID
WHERE ACTIVE = ''T'' ' );
But when it is executed with a Windows Message Broker, I get the following exception:
2013-01-02 18:18:07.559097 3912 CastException BIP2592E: Error converting character string ''9000090000900003000010000'' to decimal. State = '-1' ''S22018'' '0' ''.
Where are all the 0's coming from and how can I remove them? And there are also binary 0's in it. By the way: this is not the RowID.
The same statement works fine in a Linux Environment.
I'm using the Oracle ODBC Client. The Select statement is working with the DataDirect ODBC Client, but any update is failing with the DataDirect Client, because of: Operation not supported.
I ran reproduce the issue with MB 32-Bit and MB 64-Bit.
Thanks in advance for any idea...