RE: ORA-22816

  • From: "Christian Antognini" <Christian.Antognini@xxxxxxxxxxxx>
  • To: <tomday2@xxxxxxxxx>
  • Date: Tue, 14 Feb 2006 22:48:26 +0100

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: