OraFAQ Forum: SQL & PL/SQL » Insert multiple Picture in a table

Home » SQL & PL/SQL » SQL & PL/SQL » Insert multiple Picture in a table

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

Insert multiple Picture in a table [message #221881]

Wed, 28 February 2007 14:55

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

Report message to a moderator

Re: Insert multiple Picture in a table [message #221898 is a reply to message #221881]

Wed, 28 February 2007 22:10

BlackSwan
Messages: 26766
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.

Report message to a moderator

Re: Insert multiple Picture in a table [message #221931 is a reply to message #221881]

Thu, 01 March 2007 02:27

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

Report message to a moderator

Re: Insert multiple Picture in a table [message #221949 is a reply to message #221881]

Thu, 01 March 2007 04:37

orafaqer
Messages: 48
Registered: July 2006

Member

SQL*Loader

Report message to a moderator

Re: Insert multiple Picture in a table [message #222048 is a reply to message #221949]

Thu, 01 March 2007 09:24

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 04 18:46:42 CST 2024