Member Avatar for mayank.dyl

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.

  • 4 Contributors
  • 4 Replies
  • 133 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by rpk2006
Member Avatar for 1seo

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

Member Avatar for mayank.dyl

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

Member Avatar for debasisdas

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.