Re: Upload file

Agreed, but his original post said they were using 8i and OAS 4.0.8.1. The example he gave was practically straight out of the content services documentation. This means he was depending on the content services for his uploading. The content services (OWA_CONTENT and the attendant code in the wrb or pl/sql cartridge) receive the multipart MIME data and transparently store it in a LONG RAW column in the ows_content table. With the appropriate patches, that works flawlessly for us no matter the file type or size. No need for custom coding, or looping for that matter. However, as I mention in my first reply, I can't stand LONG RAW, so I use TO_LOB within dynamic SQL to move the file to my own table in a CLOB or BLOB column, depending on the file type. Now when the user wants to see these files again, yes I have to read it piecewise -- with looping -- back into the http response.

I'm not sure why the original author then responded asking me how to do it with WebDB 2.1. Perhaps with 2.2's tighter integration with OAS it might be possible, but I don't think he should hold his breath.

• bill c. <vietmv_at_my-deja.com> wrote in message news:8abln3$vss$1_at_nnrp1.deja.com...
  > LOB objects can only be processed in chunks of 32K, so you need to
  > write a loop to read or write until all of it is consumed.
  >
  > In article <i5Jv4.34$OX1.637_at_wormhole.dimensional.com>,
  > "Bill Coulam" <bcoulam_at_DELETECAPSusa.net> wrote:
  > > Not sure why you're having trouble with files greater than 32K.
  (snipped)