[ND] JDBC Question

[Curt Springer]

I need another set of eyes.

Here's my jdbc code, going against oracle:

        PreparedStatement pstmt = con.prepareStatement
        ("UPDATE ADEVAL.USER_PROXY set (PROXY_PRIV, LAST_UPDATED_BY, 
LAST_UPDATED_DT) = (?, ? ,?) WHERE USER_PROXY_ID = ?");

        pstmt.setString(1, request.getParameter("PROXY_PRIV"));
        pstmt.setInt(2, 
Integer.parseInt(session.getValue("SESSION_USER_ID").toString()));
        pstmt.setDate(3, new java.sql.Date(new java.util.Date().getTime()));
        pstmt.setInt(4, Integer.parseInt(USER_PROXY_ID));


        int rowcount;

try
{
        rowcount = pstmt.executeUpdate();
}//try

I'm getting a sql error:
javax.servlet.ServletException: java.sql.SQLException: ORA-01767: UPDATE 
... SET expression must be a subquery

How am I messing up the sql-- played with all sorts of options

Thx,
Curt
_________________________________________________________________________

For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html

For dire need help, email: [EMAIL PROTECTED]