Enrichment-temp table to store more than 255 character

[sachincs1991]

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

[DavidKangni · Accepted solution]

Hi Sachin,

use Edit schema activity.

Thanks,

David