Varun Chandana (VarunC72)
Infosys Ltd

Infosys Ltd
VarunC72 Member since 2016 9 posts
Infosys Ltd
Posted: January 1, 2019
Last activity: January 1, 2019
Posted: 1 Jan 2019 6:02 EST
Last activity: 1 Jan 2019 12:58 EST

ORA-12899: value too large for column


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


Low-Code App Development Data Integration
Moderation Team has archived post, 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.