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.
When you break the big rules, you get a lot of little rules.
Joined: May 02, 2007
Apparently this is a bug introduces in Oracle 10g, Bug ID 5872943. Apparently it's resolved in 11.2g.
subject: Preparedstatement updates to Oracle 10g BLOB ingnored