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

Enrichment-temp table to store more than 255 character

Avatar

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile

Avatar
Validate 1
Level 2
sachincs1991
Level 2

Likes

0 likes

Total Posts

53 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Ignite 1
Give Back 5
Give Back 3
Give Back
View profile
sachincs1991
Level 2

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
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile

Avatar
Boost 250
MVP
DavidKangni
MVP

Likes

255 likes

Total Posts

372 posts

Correct Reply

151 solutions
Top badges earned
Boost 250
Validate 1
Give Back 5
Give Back 3
Give Back 25
View profile
DavidKangni
MVP

20-01-2021

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

Answers (0)