Home » SQL & PL/SQL » SQL & PL/SQL » Insert multiple Picture in a table
Insert multiple Picture in a table [message #221881] Wed, 28 February 2007 14:55 Go to next message
ayubfkhan
Messages: 3
Registered: February 2007
Location: Baltimore
Junior Member
Hi,
I have thousands of pictures I want to upload in a Oracle table.
create table pic
(id number,
Int_date date,
pic blob);

How do I insert multiple pictures in oracle database?
because I don't want to pic one pic at a time and then populate the table.

thanks
Re: Insert multiple Picture in a table [message #221898 is a reply to message #221881] Wed, 28 February 2007 22:10 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> I don't want to pic one pic at a time and then populate the table.
Too bad to be you, 'cuz I don't think you have any alternative.
Re: Insert multiple Picture in a table [message #221931 is a reply to message #221881] Thu, 01 March 2007 02:27 Go to previous messageGo to next message
webcomsystems
Messages: 4
Registered: February 2007
Location: UK
Junior Member
Hi,

I think you've got a bit of coding ahead of you to achieve this, but it can be done.

Try http://www.jupload.biz/.

I've used this before and its very good for simultaneous multiple file uploads.

Once you upload the images they are then handled by a server script which could be PHP or JSP.

The PHP/JSP can then connect to Oracle and handle the actual insert into the field.

Hope this helps.

David Drewette
http://www.oracleunittesting.com
Best practices in unit testing for Oracle Databases
Re: Insert multiple Picture in a table [message #221949 is a reply to message #221881] Thu, 01 March 2007 04:37 Go to previous messageGo to next message
orafaqer
Messages: 48
Registered: July 2006
Member
SQL*Loader
Re: Insert multiple Picture in a table [message #222048 is a reply to message #221949] Thu, 01 March 2007 09:24 Go to previous message
ayubfkhan
Messages: 3
Registered: February 2007
Location: Baltimore
Junior Member
Thanks guys for responding to my emails,
But sqlldr doest load pictures from computer.

create table t1
(id number,
pic blob);

create or replace directory as 'c:\images';

INSERT INTO t1 (id, pic)
VALUES (123, 'bridge.jpg');

Can I insert the pictures like this? or what are the proper
steps?
Do I have to run DBMS_LOB built-in package first or something?

Thanks In advance ....

Ayub

Thanks





Previous Topic: Loop Through a String
Next Topic: tbl with two foreign keys
Goto Forum:
  


Current Time: Wed Dec 07 12:25:54 CST 2016

Total time taken to generate the page: 0.05163 seconds