I'm using Unidac 9.1.1 Delphi 10.2, recently ugraded from 8.3.2.
I have following error using Oracle DB:
Parameter 'MYPARAM': value is too long
assigning an huge string to CLOB param e.g.:
MyUniQuery.Param('MYPARAM').AsString := 'myhugestring...';
Data type of MYPARAM is not defined. If i define it as "OraClob" it works
In version 8.3.2 it was not necessary to define Data Type. Defining it as OraClob i introduce a DB dependency.
Oracle - error "value is too long" assigning huge string to clob parameter
Re: Oracle - error "value is too long" assigning huge string to clob parameter
When using CLOB parameters, we recommend explicitly specifying their type. In any case, we will investigate the behavior you describe. For this, compose and send us a small sample, which when executed causes the "value is too long" error. It is convenient to do it using the e-support form (https://www.devart.com/company/contactform.html)