Devart Forums

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.

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)