OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Insert Blob (forms 6i,oracle 9i)

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

Insert Blob [message #339167]

Wed, 06 August 2008 23:46

ns.muthukumar
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

Hi,it is Possible to storing blob in database without creating Directory?

[Updated on: Wed, 06 August 2008 23:55]

Report message to a moderator

Re: Insert Blob [message #339169 is a reply to message #339167]

Wed, 06 August 2008 23:59

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

What directory object has to do with Storing BLOB.

Regards,
Rajat

Report message to a moderator

Re: Insert Blob [message #339170 is a reply to message #339169]

Thu, 07 August 2008 00:04

ns.muthukumar
Messages: 10
Registered: June 2008
Location: INDIA

Junior Member

I saw some topic.In that topic there are told create Directory in server and put that file into that directory then only the blob is storing.Now i want to stored client side file to database it is possible?

Report message to a moderator

Re: Insert Blob [message #339176 is a reply to message #339170]

Thu, 07 August 2008 00:21

rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA

Senior Member

You can store files in oracle database via using sqlloader.
But the condition is that oracle client should be available at client machine.

UTL_FILE is able to load data only at server side and for that you need directory object.

Regards,
Rajat

Report message to a moderator