OraFAQ Forum: General » import a photo to oracle table

Home » Other » General » import a photo to oracle table

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

import a photo to oracle table [message #245901]

Tue, 19 June 2007 03:44

randritsy
Messages: 20
Registered: June 2007
Location: Dago

Junior Member

i have a .dbf table from lotus approach that contain :
matricule_agent
child
rang
phot_child
and i would like to import the photo_child into a oracle table the same structures like above table but not the same datatype as you know.
If some one can help how to do i urge.
thanks.

Report message to a moderator

Re: import a photo to oracle table [message #247180 is a reply to message #245901]

Mon, 25 June 2007 00:18

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

Senior Member
Account Moderator

Have a look at these:
Displaying Images
"Displaying Image in Forms 6i from BLOB Database field "
http://www.orafaq.com/forum/t/51889/67467/

"Displaying Image in Report 6i from named file "
http://www.orafaq.com/forum/m/157010/67467/#msg_157010

About loading and displaying images files
cs-netlab-01.lynchburg.edu/ courses/Oracle/PPTSlides/08ch.ppt
Save Images in Database From Forms - Download it Here
http://www.orafaq.com/forum/t/60477/67467/

Playing and storing sounds
http://www.orafaq.com/forum/t/51812/67467/

David

Report message to a moderator

Re: import a photo to oracle table [message #247714 is a reply to message #247180]

Tue, 26 June 2007 23:50

randritsy
Messages: 20
Registered: June 2007
Location: Dago

Junior Member

I want to say i have a photo stored in another database type .dbf (lotus approach) and i want to import its to oracle database till now i can't i don't have any method to do that.
I know how to diplay it and i know how to store it.

Report message to a moderator

Re: import a photo to oracle table [message #247723 is a reply to message #247714]

Wed, 27 June 2007 00:56

Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It is not a Forms question - I'd rather say it is related to migration from lotus approach into an Oracle database (I've heard of "Lotus", but "approach"? Is it a product name, or is approach ... well, approach?).

Report message to a moderator

Re: import a photo to oracle table [message #247756 is a reply to message #247723]

Wed, 27 June 2007 02:23

randritsy
Messages: 20
Registered: June 2007
Location: Dago

Junior Member

it's a product in lotus like lotus 123 and lotus wordperfect, it's a ibm product and approach is database tool manipulation in lotus, and it can manipulate .dbf, dbase extension file.
And, you right about lotus migration to oracle but it concerned form because i do this with oracle form.

[Updated on: Wed, 27 June 2007 02:24]

Report message to a moderator

Re: import a photo to oracle table [message #248370 is a reply to message #247756]

Thu, 28 June 2007 14:28

andrew again
Messages: 2577
Registered: March 2000

Senior Member

http://www.oracle.com/technology/tech/migration/workbench/index.html

If may be easiest to dump the images to file (not an Oracle issue) then use sql loader.
http://www.orafaq.com/faq/how_does_one_use_sql_loader_to_load_images_sound_clips_and_documents

Report message to a moderator

Previous Topic:	Oracle8 problem
Next Topic:	Database Versions and Released Year

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 04:51:24 CDT 2024