OracleCommand VARCHAR with big length

OracleCommand VARCHAR with big length

Postby 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.
Posts: 9
Joined: Thu 02 Apr 2009 21:29

Postby 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, the Index tab, OracleDbType Enumeration.
Devart Team
Posts: 7894
Joined: Thu 14 Aug 2008 12:44

Return to dotConnect for Oracle