• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
  • Junilu Lacar
  • Devaka Cooray
Saloon Keepers:
  • Ganesh Patekar
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • salvin francis
  • Ron McLeod
  • Frits Walraven
  • Pete Letkeman

Insert an image file into oracle and open image file from database?(using sql)  RSS feed

Ranch Hand
Posts: 74
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

I want to insert an image file ino oracle 9i using BLOB (without using pl/sql ,any thing) using normal sql;

I have created table as below:
CREATE TABLE test_blob (id NUMBER(15),image_name VARCHAR2(1000),image BLOB);

But I am not able to insert image file.Could you please help me in this regarding?And how to get image file using jsp ,jdbc?

thanks & regards
Ranch Hand
Posts: 338
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!