Question

1
Replies
188
Views
Close popover
Varun Chandana (VarunC72)
Infosys Ltd

Infosys Ltd
IN
VarunC72 Member since 2016 9 posts
Infosys Ltd
Posted: January 1, 2019
Last activity: January 1, 2019
Closed

ORA-12899: value too large for column

Hi,

We have a text area field which is audited using AddHistory activity. Our pyMemo has varchar2(255) - byte semantics. We are facing an issue when there is multi-byte character in the text area field which as explained in various threads we will convert it to Char Semantics. But I have a doubt with normal single-byte text scenarios

Scenario 1 :
We are facing similar Value too large issue even when there is no Multi byte character in the Textarea field and text is above 255 bytes. text has A-Z, numbers, Spaces and dots (.)

Scenario 2:
If i insert data only having (A-Z) of length more than 255 it is not throwing value too large issue even if it is more than 255 bytes and in the audit I can see this added as +. Why is this not throwing error even if it larger than 255 bytes.

P.S: I am very bad at DB .Apologize if this is a very basic stuff for you .I am still not aware of this :) . I am using PEGA 7.3.1

Thanks,
Varun

Low-Code App Development Data Integration
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.