RE: ORA-22816

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Tue, 14 Feb 2006 22:48:26 +0100
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF205C85@MSXVS04.trivadis.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Feb 14 2006 - 15:48:26 CST