I am using VB (ADO) to insert data into an Oracle (9i) database and
would like to update a Long Raw data field with text over 4000
characters using.

conn.Execute 'UPDATE MYTABLE SET LONGRAWFIELD='7F000E000....'

This works up until 4000 characters (then I get a String too long
error).  I tried breaking up the string (SET
LONGRAWFIELD='7F000E000...' || 'AB00000...') but then I get a
Concatenated String too long error.

I would prefer doing it with a direct Update to the database (or some
other way using just the connection object).  If this is not possible,
please send me a recordset example.

---

Clarification of Question by ny_insomniac-ga on 23 Jul 2004 11:15 PDT

The field that I'm putting data into is a LONG RAW, and I have over
4000 characters of Hexidecimal.  Can you give me an example of using a
blob function within Visual Basic or a sql statement to do this?

Oracle doesn't support updates through a VARCHAR2 column of more than 4K (and
it used to be 2K).  You have to use blob functions to update anything larger
than that.


http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&threadm=ITrx8Vcn%23GA.203%40forums.sybase.com&rnum=3&prev=/groups%3Fq%3Doracle%2Bmaximum%2Btext%2Bsize%2Bupdate%2B4000%26hl%3Den%26lr%3D%26ie%3DUTF-8%26selm%3DITrx8Vcn%2523GA.203%2540forums.sybase.com%26rnum%3D3