Long column update problem

Dear All,

Problem:
In Oracle database, we have a column of type LONG. We use .Net OLEDb technology for database access.
For update we use OleDbParameter . But problem is, if LONG string size is more than 4000, it gives error:  

Error Details:
Error Code: "ORA-01036"
Error Desc: " illegal variable name/number"    

Code details:
OleDbParameter oleParameter = new OleDbParameter(); oleParameter.DbType = DbType.String; // it accepts only string of size 4000

//oleParameter.OleDbType = OleDbType.LongVarWChar;

oleParameter.ParameterName = @"Memo"; // Long column name oleParameter.Value = _ParameterValue;

Is there something wrong in this code?

Please help...

TALIA
Many Regards
Sunil Received on Sun Dec 14 2003 - 22:12:51 CST