EdStevens wrote:
> Platform: Oracle 9.2.0.7 on AIX 5.3
>
> Developer presented me with this:
>
> I am trying to use the RETURNING... INTO... clause on an Oracle insert
> statement but am getting the following error:
>
> java.sql.SQLException: ORA-00439: feature not enabled: RETURNING clause
> from this client type
>
> I asked for the entire sql statement, etc ...
>
>
> Database: ACIPMDV
> Version: Oracle9i Enterprise Edition Release 9.2.0.7.0 - 64bit
> Production
> (As shown in SQLPlus)
>
> INSERT INTO CORE.CZ_AUD (
> AUD_MAINT_SIN,
> AUD_OPER_ID,
> AUD_BU,
> AUD_PROD_SPROD_IND,
> AUD_ACTVTY_TS,
> AUD_UI_DESC)
> VALUES (
> 228,
> '1347413030'
> ,62,
> 'PL',
> sysdate,
> ' ')
> RETURNING AUD_CHG_SIN INTO {variable name}
>
>
> Ideas?
>
Apart from the ugly space in the insert,
the error tells is the *client*.
Now, I don't know if thin or thick jdbc allow this, but
I think both did.
--
Regards,
Frank van Bortel
Top-posting is one way to shut me up...
Received on Mon Apr 24 2006 - 13:39:17 CDT
