This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
Hi, I'm trying to use an updateable record set, however whenever I update a row, I get the error " ORA-00907: missing right parenthesis". The query I use to get the record set is fine as I can extract the selected values. I just can't call updateRow(). Has anyone come across this? My code is:
Very strange message indeed. The error message appears to have nothing to do with (what I think is) the problem. According to Oracles documentation ( http://download-west.oracle.com/docs/cd/A97630_01/java.920/a96654/resltset.htm#101813, scroll down to "FOR UPDATE Clause Limitation in an Updatable Result Set"), you can't use a FOR UPDATE clause with an updatable result set. The documentation also lists some other limitations, but I don't think you are violating any of them. [ December 12, 2002: Message edited by: Kevin Mukhar ]
Joined: Dec 11, 2002
Thanks Kevin, Removing the "For Update" fixed it. I'm learning to take Oracle errors with a grain of salt. When I was working with Perl's DBD library (a wrapper around Oracle's OCI drivers), I got an error stating: "You must install a Solaris patch to run this version of the Java runtime". The real problem was that I'd forgotten to add the Oracle library path to LD_LIBRARY_PATH. How that relates to a Java runtime, I have no idea. Thanks, Terry