Thomas >We're doing an INSERET through a view. The insert statement is pretty >straight-forward and doesn't have any apparent subqueries. It works >fine if I run it in SQLPlus. However, we're running it through Java >and an ODBC connection. Which version of the JDBC driver are you using? I ask because the RETURNING clause is supported in 10gR2 only. And, in addition, only if you use Oracle extensions. Otherwise you have to use the standard JDBC interface that has a similar feature called Auto Generated Keys. HTH Chris -- //www.freelists.org/webpage/oracle-l