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 (.)
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