Reading CLOB Column in DS 8.7

[bgudapati]

Hi

I am trying to read CLOB columns in DataStage 8.7. Here is the case

Extract Query, working fine in oracle

SELECT PLACEMENT_ID,
DBMS_XMLGEN.CONVERT (
RTRIM (
XMLAGG (XMLELEMENT (e, TARGETED_ID || CHR (13))).EXTRACT ('//text()').getclobval (),
','),
1)
INCLUDE_SITE_SECTION_IDS,
DBMS_XMLGEN.CONVERT (
RTRIM (XMLAGG (XMLELEMENT (e, NAME || CHR (13))).EXTRACT ('//text()').getclobval (),
','),
1)
INCLUDE_SITE_SECTION_NAMES
FROM (SELECT CGT.PLACEMENT_ID, CGT.TARGETED_ID, S.NAME
FROM CONTENT_TARGETING_BGD CGT, SITESECTION S
WHERE CGT.TARGET_TYPE = 'SITE_SECTION'
AND CGT.TARGETING_TYPE LIKE '%Include%'
AND CGT.TARGETED_ID = S.ID)
GROUP BY PLACEMENT_ID

Reading 2 CLOB Columns as LongNVarChar in DS

Issue:

DS is throwing below error

The OCI function OCILobRead returned status -1. Error code: 24,806, Error message: ORA-24806: LOB form mismatch. (CC_OraInputStream::read, file CC_OraInputStream.cpp, line 681)

Can you please help to resolve the above issue

[ray.wurlod]

For a definitive statement go to the IBM Information Center for Information Server v8r7

I don't see anywhere in your SQL where you are using CAST to convert to Long VarChar2. Is this implicit in the CONVERT() function?