Long value does not populated in exposed column
Hi,
I got ORA-01461 error when I entered long value (more than 4000 bytes) for exposed column A that data type is VARCHAR2 (4000 byte).
And I also fine related article in PDN (https://pdn.pega.com/support-articles/bind-long-value-only-insert-long-column-exception).
But for some column, like pymemo of PC_LINK_ATTACHMENT, I can enter long value (more than column defined byte) when I attached long name file, because PRPC cutoff the value to maximum data size of the column.
Is there any definition in PRPC to cutoff long value before DB commit?
What is the difference between above 2 tables?
Thanks in Advance
Regards,
Haruka Kondo
***Updated by moderator: Lochan to add Categories***
Siemens
IN
Hi,
I am not really sure of the difference in the tables. One way to make sure the string contains the required number of characters is by using the OOTB "sub-string" function and trimming the extra characters away.
Alternatively you can also use validation to check the number of characters entered, and prompt the user to enter only specific number of characters.
Hope that helps.
Kondo
Hi,
Thank you for your reply.
I create MasterDataMaintenance Section in Data-Portal class, display row data from Report Definition, and set "Row editing" as "Inline".
And I understand this "Row editing" does not have the function to (1) cutoff the entering value for exposed column and (2) insert the full value to BLOB, like PRPC does for PC_LINK_ATTACHMENT.
I will check another way to implement the function (1) and (2) for our MasterDataMaintenance Section.
Thanks,
Haurka Kondo