Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Enrichment-temp table to store more than 255 character

Avatar

Level 3

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

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

View solution in original post

1 Reply

Avatar

Correct answer by
Community Advisor

Hi Sachin,

 

use Edit schema activity.

Thanks,

David