IBM InfoSphere Streams Version 4.1.0

Invalid SQL data type errors occur with SPL int64 data types and Oracle databases

If you have data that is an INTEGER data type in a table in an Oracle database, and you attempt to send or receive data by using an int64 data type in an SPL application, invalid data type errors can occur.

Symptoms

The SQL error message that occurs in this situation is: [Oracle][ODBC]Invalid SQL data type <-25>.

Causes

ODBC libraries for Oracle do not support the SQL_C_SBIGINT ODBC type, which corresponds to the int64 SPL type.

Environment

This problem occurs in the following circumstances:
  • Database: Oracle.
  • Operating system: All.
  • Drivers: All.

Resolving the problem

There is no workaround. If you use an Oracle database, do not use the SPL int64 type in your applications.
Parent topic: Database Toolkit problems and solutions