String (Unlimited) In Oracle Converts to NCLOB with only 4000 characters
We have an Issue where we need to upload an HTML Template which is used as a request form. In Mendix, We have defined t datatype as String (Unlimited). Since we are using an Oracle database, this datatype is converted to a NCLOB in Oracle Database which accepts only 4000 characters i.e. 4000 bytes. Our templates are much bigger and running into over a 100 thousand characters which is not accepted in the NCLOB. Is there any workaround to this Limitation in Mendix.
I faced the same error. Did you found the solution.
I got the same issue. But the bigger issue once it is converted to nlob, you cannot reduce the length to 2000 for an example, the Oracle doesn’t allow you to modify the column nlob back to nvarchar2(2000)