OCI/Blobs/Oracle 8 oddness

given a table with the columns like:
  number NUMBER(10)
  text VARCHAR(10)
  blob1 BLOB
  blob2 BLOB

what's the correct way to insert a complete row? I thought I could simply

• alloc the lob locators,
• prepare the statement,
• bind the values (number, varchar and both blobs),
• do an execute, and then
• do the lob writes.

however, I get ora 22275 ("invalid LOB locator specified") on the statement execute.

Do I have to do something completely silly like insert the number/text, select them for update, then do the lob writes? (Egads, I hope not.)

--
J. Eric Townsend jet at liquidaudio.com, +1 650.549.2056 Liquid Audio http://www.liquidaudio.com Received on Tue Apr 28 1998 - 23:00:40 CDT