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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Enrichment-temp table to store more than 255 character

sachincs1991
Level 3
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
DavidKangni
Correct answer by
Community Advisor
Community Advisor

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

View solution in original post

1 Reply
DavidKangni
Correct answer by
Community Advisor
Community Advisor

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

View solution in original post