ADD big Text to a Clob Fileld with update (50 MB) in Oracle (ORA-01461)
693132Mar 26 2009 — edited Mar 27 2009I want to add a text to an existing clob field (VB.net) . The update Text is bigger then 50 MB.
When i update (add text) the filed i get always the error message "ORA-01461: can bind a LONG value only for insert into a LONG column".
Here my code:
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
cmd.CommandText = "update INTERFACEDATA.MSGRAWMESSAGES set MESSAGETEXT = MESSAGETEXT || :MESSAGETEXT where RAWMSGNR=10938"
cmd.Parameters.Clear()
cmd.Parameters.Add(":MESSAGETEXT",OracleType.Clob).Value = FileDataStream 'Filedatastream is a text that is bigger then 50 MB.
cmd.ExecuteNonQuery()
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Does anybody know a solution for this problem?
it would help me a lot!