• 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 ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Jeanne Boyarsky
  • paul wheaton
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Stephan van Hulst
  • Ron McLeod
  • Tim Moores
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Vijitha Kumara

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
Hello,

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
Sri
 
Ranch Hand
Posts: 338
 
I got this tall by not having enough crisco in my diet as a kid. This ad looks like it had plenty of shortening:
global solutions you can do in your home or backyard
https://coderanch.com/t/708587/global-solutions-home-backyard
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!