CLOB-> LONGNVARCHAR

deeplind07 · Post by **deeplind07** » Wed Oct 03, 2012 2:49 am

Hi,

Can some one tell me the maximum length of characters that oracle connector stage can read and process in datastage.

I have 5 column maximum 12000 char each long(Clob datatype in oracle). i want to concatenate these columns and then split the note into 4000 characters each and create new records for each 4000 chars.

Is it possible ? what datatype do i need to select ,is there any propety setting in the oracle connector to read this long data?

Thanks!!
DD

chulett · Post by **chulett** » Wed Oct 03, 2012 7:07 am

What happened when you tried? What datatype did you get for those fields when you imported the metadata? For your first question, I would ask that of your official support provider. I'd also be curious what exact 8.x version you have.

ray.wurlod · Post by **ray.wurlod** » Wed Oct 03, 2012 3:21 pm

You might try CAST (columname AS LONG VARCHAR2(20000)) in your user-defined query.

deeplind07 · Post by **deeplind07** » Wed Oct 03, 2012 7:26 pm

I am not sure of the official service provider.

When i imported the metadata it gave longnvarchar (2147483647).
We are using version8.1.

I am able to 'view data' in the oracle connector. But when i try to insert data by doing 1;1 mapping in transformer for each field it is throwing the below error

'Oracle_Connector_6,1: Operator terminated abnormally: received signal SIGSEGV'

ray.wurlod · Post by **ray.wurlod** » Wed Oct 03, 2012 8:57 pm

Try cutting the length in the metadata back to a sufficient length (4000 probably).