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.
Linkelf
 
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 http://www.devart.com/dotconnect/oracle/docs, the Index tab, OracleDbType Enumeration.
Shalex
Devart Team
 
Posts: 7793
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle