Re: ORA-22816

  • From: Thomas Day <tomday2@xxxxxxxxx>
  • To: Christian Antognini <Christian.Antognini@xxxxxxxxxxxx>
  • Date: Wed, 15 Feb 2006 13:23:33 -0500

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


Other related posts: