Re: OAS file upload

I've not tried the examples you describe, but we use the file upload abilities heavily with our production trouble ticket OAS-based system. My users upload .xls, .doc, .txt, emails (txt) and other stuff into the DB, most bigger than 32K (by the way, I go through some PL/SQL nastiness to get the information out of the websys user's content tables and into my own tables where the columns storing the information are either CLOB or BLOB type, where they can be searched and read back in a download request easily. The LONG RAW just isn't helpful to me in ows_content.) Anyway, this was all working until we overwrote our 4.0.7.1 install of OAS with 4.0.8.0. If you didn't know already (I didn't ), 4.0.8 was a complete re-write of the core ORB that OAS revolves around. Despite the length of time it took to release it, it had major bugs that indicated not much regression testing was done. One of them completely broke the file uploads feature in my system. I had to go through 2 months of debugging hell, wait for 4.0.8.1, and apply two more patches on top of that, to get to where we are today: back to where we were before the 4.0.8 goof. Moral: Get 4.0.8.1 as soon as you can, force them to tell you of any known patches for your OS that have been released since 4.0.8.1, and never install a new version over a working version of OAS.

-best 'o luck, bill c.

CASISOFT MindWare wrote:

> Hello,
>
> we tried the example in Oracle Application Server Developer's Guide:PL/SQL
> And ODBC Applications page 4-11 ... 4-14.
> The example works, but only until file size about 32000 Bytes. As to read on
> page 4-11 the limit is at 8 million byte.
> The parameter file of procedure write_info is VARCHAR2. This could explain
> the limitation of file size 32000 bytes. But why do they write about a limit
> of 8 million byte? For our project it necessary to handle larger files!
>
> Our system:
>
> NT 4.0 SP 5 (german) with marta.dll hotfix
> IIS 4 (german)
> OAS 4.0.8.0.0 (english)
> Oracle 8.0.5 (english)
>
> Thanks for help!
>
> Wolfgang Fürniß
Received on Mon Jan 24 2000 - 10:38:35 CST