Re: OAS 408 PL/SQL file upload/download

Hello,

I tried the example (Oracle Application Server Developer's Guide:PL/SQL And ODBC Applications page 4-11 ... 4-14.)
The content of the file will be found in table "mytable" field "file" It works, but when the file is larger than about 32500 bytes the following error appears:

OWS-05101: Execution failed due to Oracle error 1460 ORA-01460: unimplemented or unreasonable conversion requested

The error appears also, when I only show the content of the file on screen.

What to do to solve this?

Thanks for any ideas!

Wolfgang Fürniß

wutang_warrior_at_my-deja.com schrieb in Nachricht <86cmel$25l$1_at_nnrp1.deja.com>...
>This has also baffled me, Has anyone done it?
>Please share how / sample code?
>
>B.T.W. There is a limitation in OAS 4 that the max upload file size
>--
>htp.p ('<input type="file">');
>--
>can only be 8 million bytes or less <---- This IS in the Doc's. This is
>solved by using another listener, e.g. IIS or Apache.
>
>
>
>
>
>
>In article <3887D1D5.59BFDF6A_at_hotmail.com>,
> NO_SPAM_steviep9_at_hotmail.com wrote:
>> I believe the file gets uploaded to the websys schema in the database.
>>
>> Gary Perkins wrote:
>>
>> > The example for uploading a file from a client browser in the OAS
>online
>> > doco doesnt tell me where the file should go and it doesnt work??
>Is there
>> > an obvious setup trick that they have doco'd or I didnt read?
>>
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Jan 24 2000 - 06:18:31 CST