ORA-22816 -- Christian Antognini 2006-02-14
ORA-22816 -- Thomas Day 2006-02-15
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@(protected):
> >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.