How to store 30 thousand characters or more in a field of a datatype
I currently have a requirement to store Base64 characters in a text or paragraph property of a datatype.
When I do it in Pega Personal Edition I have no problem putting 30 thousand characters as the length and I see that postrgres is used as the database, it automatically creates a varchar(30000).
However, in my work portal, Oracle 16c is being used for the CustomerData database, where my DataType table is, and when trying to create a field of 30000 as the length, just like in the personal edition, here it sends me an error:
ORA-00910: specified length too long for its datatype
I understand that it is size restricted as I have verified that it only creates fields of up to 4000 characters. But why in the Personal Edition if it allows more and in this enterprise version it doesn't? Does it have to do with the Oracle Database manager?
I have tried creating the field with a default size of 250 characters and then I have requested that it be modified directly in the Database to 30k, but they tell me that this error has been thrown:
Problem executing SQL to update database schema : alter table SCH_PEGA_DATA.PR_CITI_DCM_DATA_INFOCHEQUESME add "IMAGENANVER" VARCHAR2(30000 CHAR)
I have requested that the CLOB type field be created in the datatype table directly with the Oracle manager but when I try to add it later to my data model in Paste, it throws an error that the field exists but is not exposed.
I currently have a requirement to store Base64 characters in a text or paragraph property of a datatype.
When I do it in Pega Personal Edition I have no problem putting 30 thousand characters as the length and I see that postrgres is used as the database, it automatically creates a varchar(30000).
However, in my work portal, Oracle 16c is being used for the CustomerData database, where my DataType table is, and when trying to create a field of 30000 as the length, just like in the personal edition, here it sends me an error:
ORA-00910: specified length too long for its datatype
I understand that it is size restricted as I have verified that it only creates fields of up to 4000 characters. But why in the Personal Edition if it allows more and in this enterprise version it doesn't? Does it have to do with the Oracle Database manager?
I have tried creating the field with a default size of 250 characters and then I have requested that it be modified directly in the Database to 30k, but they tell me that this error has been thrown:
Problem executing SQL to update database schema : alter table SCH_PEGA_DATA.PR_CITI_DCM_DATA_INFOCHEQUESME add "IMAGENANVER" VARCHAR2(30000 CHAR)
I have requested that the CLOB type field be created in the datatype table directly with the Oracle manager but when I try to add it later to my data model in Paste, it throws an error that the field exists but is not exposed.
Is there anything I can do? What I am trying to do is store 30k characters in a text property in a datatype but the database manager in Oracle 16c.
Thank you very much!