OraFAQ Forum: WebCenter Suite & Portal » Oracle 9i File Uploading Problem

Home » Fusion Middleware & Colab Suite » WebCenter Suite & Portal » Oracle 9i File Uploading Problem

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 9i File Uploading Problem [message #108676]

Mon, 15 November 2004 23:34

Ashwin Mittal
Messages: 2
Registered: November 2004

Junior Member

Hi All,

Myself Ashwin Mittal, I am new to Oracle 9i.

Can anybody tell me how I can upload File in Oracle9i..

Thanking in advance..

Waiting for reply asap.

Regards,

Ashwin Mittal.

Report message to a moderator

Re: Oracle 9i File Uploading Problem [message #149606 is a reply to message #108676]

Fri, 02 December 2005 08:02

fjfish
Messages: 16
Registered: December 2005
Location: UK

Junior Member

Hi,

I've just been fighting with this one myself. I found the answer here:

http://www.oracle-base.com/articles/9i/FileUploadDownloadProcedures9i.php?display_type=printable

In esssence, if you are using mod_plsql, the software will do it for you and put it in a table you nominate in the DAD.

Writing this back out again you can use Java or utl_file.

Hope this helps.

Report message to a moderator

Re: Oracle 9i File Uploading Problem [message #150442 is a reply to message #108676]

Wed, 07 December 2005 19:51

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search the 'Forms' forum for 'blob'. There are a few solutions listed there.

David

Report message to a moderator

Re: Oracle 9i File Uploading Problem [message #150492 is a reply to message #150442]

Thu, 08 December 2005 03:04

fjfish
Messages: 16
Registered: December 2005
Location: UK

Junior Member

If and only if you want to use client/server text_io and forms? Which is terribly slow.

Also, if you're running web forms, the file will need to be on the middle tier already. There is a Java Bean to move files for forms but it will only put things on the middle tier. In the UK we have a phrase: "as much use as a chocolate teapot". If you're running a *nix implementation you can mount a file system from the middle-tier server onto the database server and away you go, but windows is much harder because of its single-user nature and most of my clients run windows, 'cos they prefer the enemy they know.

I've been through this already.

Or maybe I'm wrong? If there is a way to get stuff straight onto the database server from web forms without some horrible Apache/windoze services kludge please tell me.

Smile

Report message to a moderator

Re: Oracle 9i File Uploading Problem [message #150667 is a reply to message #150492]

Fri, 09 December 2005 00:17

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search the forms forum for 'webutil'. There are both 'host' and 'client_host' commands available.

David

Report message to a moderator

Previous Topic:	loading the BFILE-stored picture into HTML
Next Topic:	Oracle Portal History

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 14:22:52 CST 2025