Question

2
Replies
179
Views
Haruka Kondo (HarukaK6)
Kondo

Kondo
HarukaK6 Member since 2015 5 posts
Kondo
Posted: August 9, 2017
Last activity: August 9, 2017
Posted: 9 Aug 2017 0:12 EDT
Last activity: 9 Aug 2017 12:18 EDT
Closed

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***

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.