Devart Forums

Is it possible to pass strings to VARCHAR parameter without setting max_size? I need to pass large data with undetermined length.

OracleDbType.VarChar corresponds to Oracle's VARCHAR2 datatype maximum size of which is 4000 bytes. If you need to store large amount of data, please take a look at the OracleDbType.Clob and OracleDbType.Long datatypes. For more information, please refer to http://www.devart.com/dotconnect/oracle/docs, the Index tab, OracleDbType Enumeration.