Enrichment-temp table to store more than 255 character

Avatar

Avatar

sachincs1991

Avatar

sachincs1991

sachincs1991

19-01-2021

Hi Team,

 

I am concatenating string in the enrichment using group by and the length is exceeding more than 255 characters once it executes and unable to store in temp schema.

 

01/19/2021 2:45:09 AM   ORA-210000 Oracle error: ORA-01489: result of string concatenation is too long

 

Kindly help and suggest.

 

Thanks,

Sachin C S

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

DavidKangni

MVP

Avatar

DavidKangni

MVP

DavidKangni
MVP

20-01-2021

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

Answers (0)