Home » Other » General » import a photo to oracle table
import a photo to oracle table [message #245901] Tue, 19 June 2007 03:44 Go to next message
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.
Re: import a photo to oracle table [message #247180 is a reply to message #245901] Mon, 25 June 2007 00:18 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: import a photo to oracle table [message #247714 is a reply to message #247180] Tue, 26 June 2007 23:50 Go to previous messageGo to next message
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.
Re: import a photo to oracle table [message #247723 is a reply to message #247714] Wed, 27 June 2007 00:56 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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?).
Re: import a photo to oracle table [message #247756 is a reply to message #247723] Wed, 27 June 2007 02:23 Go to previous messageGo to next message
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 Go to previous message
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


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


Current Time: Fri Dec 09 11:55:33 CST 2016

Total time taken to generate the page: 0.10894 seconds