Is it possible to store images in oracle db, if yes then what will be the data type of the field.? Please illustrate with example....thanx a lot.

Recommended Answers

All 4 Replies

Store image path in text format in database.Then use image file upload and Download control for retrieving image.

thats cool...but what if i wants to store images as it is in db and retrieve them by using some query.?

You need to follow these steps.

To Store
----------
1.read the image file.
2.convert the same to binary stream.
3.store in BLOB field.

To Retrieve
--------
4.read from db
5.convert back the binary stream.
6.display as desired in front end application.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.