Reading/writing Oracle CLOB Datatype

[smart2786]

Hi Experts,

As per my knowledge Oracle CLOB datatype is equals to LongNvarchar in Datastage.

when i am trying map CLOB data type field from oracle to LongNvarchar in filed in Datastage i am getting unsupported data type error.

I could not able to import metadata from oracle table because of CLOB datatype.

Is there any Environmental Variables need to be set to over come this issues?

Could you please share your valuable suggestions on this?

Thanks
kumar

[blewip]

Are you using the Oracle connector?

In the Connector Stage a CLOB equates to a Long Varchar

[tbharathkumar]

RAW(n) datatype not supported in datastage oracle connector, So CLOB datatype may also not supported. If oracle record length exceeds 32KB then job aborts...Pls advice if wrong.

[blewip]

I've never used RAW, however from the 8.5 manual

Oracle LOB and XMLType data types
The Oracle connector supports reading and writing Oracle LOB data types BFILE,BLOB, CLOB, NCLOB, LONG RAW, RAW, and XMLType.

[tbharathkumar]

We are in datastage version 8.1, i guess your answer is correct for Datastage ver 8.5

[smart2786]

Hi ray,

Could you please help on this??

Thanks

[ray.wurlod]

Hi ray,

Could you please help on this??

Thanks

That is not how DSXchange works. Any people who feel they can contribute something are welcome to do so. And anyone who feels that he or she can not contribute anything useful are at liberty to remains silent; there is no compulsion on anyone.

[blewip]

Are you using the Oracle connector?

Did you clarify that you were using the Connector, not the Enterprise / Other Stage?