OK. It doesn't work with the 10gR2 JDBC driver. It DOES work with 9i. Now I've got to figure out why. On 2/14/06, Christian Antognini <Christian.Antognini@xxxxxxxxxxxx> wrote: > 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