> PreparedStatement pstmt = con.prepareStatement
> ("UPDATE ADEVAL.USER_PROXY set (PROXY_PRIV, LAST_UPDATED_BY,
> LAST_UPDATED_DT) = (?, ? ,?) WHERE USER_PROXY_ID = ?");
>
> I'm getting a sql error:
> javax.servlet.ServletException: java.sql.SQLException: ORA-01767: UPDATE
> ... SET expression must be a subquery
I am not an SQL expert, but the way I always use update is like this:
update table set field1=?, field2=?, ... where ...
You can try whether this would work.
Denis.
_________________________________________________________________________
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]
