CLOB datatype

[Sachin.tilloo]

Hi All,

In one of my Extraction query field is having datatype as CLOB . while viewing the data through datastage i am getting the following error.

"Error executing View Data command:

##F TUXX 000002 16:07:29(000) <main_program> Internal Error: (colDesc):orautils.C: 1803: getColDesc failed."
while in server edition the data can be viewed using longVarchar(4000) for that field.

I am using longVarchar(4000) for that field in datastage.
please help what datatype should i use in datastage.

Thanks for the Help

[ray.wurlod]

Try VarChar(4000).

[Sachin.tilloo]

Hi
I have also tried varchar(4000) but the same error is coming

Thanks.