Storing image in table.

[Parul Bagadia]

Hello,
For my project in Oracle, i need to store an images in 2 tables,... actually my front-end in the project is VB amd oracle is the back-end; so anybody has got the idea how do we store images in oracle; may be i can store the path or sth?

[debasisdas]

you have two options

1.store path of the file

For this you need to store tha path of the file in varchar field. retrive the name ande read the file. but in this option if the actual file is deleted you are in trouble.

2.store the actual image in the database itself

For this option you need to convert the image file into binary stream and store the same in the database table in a BLOB field. you can terive the same stream and convert back to get back the actual image.