• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Preparedstatement updates to Oracle 10g BLOB ingnored

 
Matthew Snow
Ranch Hand
Posts: 82
  • 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
  • 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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic