Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

inserting jpg/gif in oracle

 
padmanabh dongre
Greenhorn
Posts: 24
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

HI

I am getting the following error when i execute the following line.
rs = stmt.executeQuery("SELECT FILEDATA FROM TMPBLOB WHERE FILENAME='test.jpg' FOR UPDATE");
where FILEDATA is of type BLOB.
Error : java.sql.SQLException : General error
when i try the following Select query on SQL prompt
SELECT FILEDATA FROM TMPBLOB;
I get the error message : Column or attribute type can not be displayed by SQL*Plus
why this should happen ??
thank you.
Padmanabh

 
sanjay yermalkar
Greenhorn
Posts: 23
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Error : java.sql.SQLException : General error

Could you please describe this more? may be a printStackTrace will help.
I also get the same error in SQL plus, i think it cannot display binary data types.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic