Load Data Type CLOB with Informatica (Error: ORA-00932

[SupportBamako]

Hello,

I am trying to debug a mapping in which i have a source and targert as relation database (Oracle 9i)
The two tables in the database had one columns (COMMENTS) type CLOB.
In the Source Qualifer of my mapping the field I try different Datatype (string, text, binary, whith prec 65535) but i have the same error
when i run my debegger

CMN_1038 Oracle Error
CMN_1038 [SQL Stmt : SELECT T_PR_DOCUMENT.ID_DOCUMENT, T_PR_DOCUMENT.ID_PROJET, T_PR_DOCUMENT.ID_TYPEDOCUMENT, T_PR_DOCUMENT.ID_INTERVENANT, T_PR_DOCUMENT.TXT_COMMENTAIRE, T_PR_DOCUMENT.TXT_CHEMINDOCUMENT, T_PR_DOCUMENT.DAT_DOCUMENT, T_PR_DOCUMENT.DAT_CRDOCUMENT, T_PR_DOCUMENT.DAT_MAJDOCUMENT, T_PR_DOCUMENT.USR_CRDOCUMENT, T_PR_DOCUMENT.USR_MAJDOCUMENT FROM T_PR_DOCUMENT
Function: Fetch
Error: ORA-00932: Types de données incohérents
]

Please let me know if you have any suggestion regarding this.

 

[smajay]

Hi,

Informatica doesn't support CLOB data type. Even if you change the data type in source it doesn't work since informatica is unable to read CLOB data type. So you need to change the CLOB data type at source atleast.


-Ajay