image from db to local drive

[cmuraz]

helo all,

i need to get image files from oracle database to local drive say "c:\photos"

i dont know the procedure to do it. i want to know how to do it and in which format i ll get in the local drive

pls help me regarding this.

thanks and regards

muthu

[debasisdas]

How you have stored the data in the database ? It is the file or the file path only.

[cmuraz]

i ve stored the image in the column. not the external file.

[debasisdas]

You need to use some frontend tool for that. You need to convert the binary stream to recreate the file.

[amitpatel66]

Can you post the table structure in which you have stored the image file?

[cmuraz]

ADM_NO CHAR(7) [primary key]
PHOTO LONG RAW

this is the structure of the table

[cmuraz]

thanks mr.debasisdas
can i know whats the front end tool to extract it?
im using forms 6i in which i can view it. but i cant save to a client system folder. or is there any method in forms 6i to save to a local system?