• 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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!