Enrichment-temp table to store more than 255 character | Community
Skip to main content
Level 3
January 20, 2021
Solved

Enrichment-temp table to store more than 255 character

  • January 20, 2021
  • 1 reply
  • 1368 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by DavidKangni

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

1 reply

DavidKangni
Community Advisor
DavidKangniCommunity AdvisorAccepted solution
Community Advisor
January 20, 2021

Hi Sachin,

 

use Edit schema activity.

Thanks,

David

David Kangni