OracleCommand VARCHAR with big length

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
Linkelf
Posts: 9
Joined: Thu 02 Apr 2009 21:29

OracleCommand VARCHAR with big length

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
Site Admin
Posts: 8241
Joined: Thu 14 Aug 2008 12:44

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.

Post Reply