How can I insert/update LONG RAW data?

Hi,

I think the subject says it all.
Additional Information:
1. I'm using Oracle 8.03.
2. I access the Oracle with ODBC.

I already tried the following in SQL*Plus:

  insert into MyTable (MyID, LongRawCol)   values (1, HexToRaw('1234567890ABCDEF012........')

with a hex string of length of 1000 bytes. (In real world we want to handle raw data of size > 2k.)
It did not work unless I cut the string down to a length of 255 bytes.
So I got the idea of updating the row and append chunks of data by:

  update MyTable
  set LongRawCol = HexToRaw(RawToHex(LongRawCol) || '0123454...')   where MyId = 1

But as you can imagine this did not work because inside this expression there appear values with size > 256 bytes.

How can I get this working?

Or isn't there any way to insert LONG RAW data > 256 bytes ?-(

Thanks for any help
Michael

-- 
*********************************************************
                    Michael Jenc
                 CAS Software GmbH
                 Karlsruhe, Germany

Replace the '_' with '-' in E-mail address to contact me