OracleCommand VARCHAR with big length

Linkelf · Post by **Linkelf** » Tue 12 Jan 2010 11:06

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

Shalex · Post by **Shalex** » Wed 13 Jan 2010 11:00

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.