Oracle Data Source JDBC Error with LONG Data Type

[redspark]

Hi,

We have a multi-query Cognos Report that that selects on a LONG data type from Oracle. LONG data types are deprecated but still useable within Oracle 12. When the query is processed, Cognos reports the error: XQE-DAT-0001 Data source adapter error: java.sql.SQLException: Stream has already been closed.

Has anyone experienced this issue with any of your environments? If so, please tell us how was it solved or worked around or if we are SOL.  ;)

Thank you.

James

[adam_mc]

We have some CLOB columns in an Oracle data source which provided similar problems.

We got around these problems by casting the column name in Framework Manager as follows:

   cast( substring([CLOB_Column_Name], 1, 4000) , varchar(4000))

Maybe something like this will work for you?

Hope this helps,
Adam.