IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • No replies
ChB
ChB
1 Post

Pinned topic [8.0.0.1 Windows] ODBC CAST Exception with numbers

‏2013-01-02T17:39:50Z |
Hello Group,

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
FROM SP_SCHEDULER
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...

Chris