File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Preparedstatement updates to Oracle 10g BLOB ingnored

 
Matthew Snow
Ranch Hand
Posts: 82
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is my code.



When I run pstmt.execute() it returns a false with pstmt.getResultSet() returning null and pstmt.getUpdateCount() returning 1. If I use pstmt.executeUpdate(), it returns 0. Could someone explain to me why this Update statement wont execute? Thanks.

Update: if I change the statement to an Insert with a new value, I get the following error: ORA-01460: unimplemented or unreasonable conversion requested.
 
Matthew Snow
Ranch Hand
Posts: 82
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Apparently this is a bug introduces in Oracle 10g, Bug ID 5872943. Apparently it's resolved in 11.2g.
 
Don't get me started about those stupid light bulbs.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic