Home » SQL & PL/SQL » SQL & PL/SQL » Insert Blob (forms 6i,oracle 9i)
Insert Blob [message #339167] Wed, 06 August 2008 23:46 Go to next message
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 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
What directory object has to do with Storing BLOB.

Regards,
Rajat
Re: Insert Blob [message #339170 is a reply to message #339169] Thu, 07 August 2008 00:04 Go to previous messageGo to next message
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?
Re: Insert Blob [message #339176 is a reply to message #339170] Thu, 07 August 2008 00:21 Go to previous messageGo to next message
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
Re: Insert Blob [message #339179 is a reply to message #339167] Thu, 07 August 2008 00:34 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can also write your own program to read the file on client and write it as a blob in the database.

Regards
Michel
Re: Insert Blob [message #339193 is a reply to message #339179] Thu, 07 August 2008 01:11 Go to previous messageGo to next message
ns.muthukumar
Messages: 10
Registered: June 2008
Location: INDIA
Junior Member
Any one give idea for storing client side file in databse
Re: Insert Blob [message #339201 is a reply to message #339193] Thu, 07 August 2008 01:21 Go to previous message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
We have already given you ideas??

What else you require??

Do you wan't us to show you a demo so that you just copy and paste that. Shocked

Try doing some google.


Regards,
Rajat
Previous Topic: need solution
Next Topic: Display results from Oracle Stored Procedure
Goto Forum:
  


Current Time: Sun Dec 04 10:49:32 CST 2016

Total time taken to generate the page: 0.10493 seconds