Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> ORA-00439

ORA-00439

From: EdStevens <quetico_man_at_yahoo.com>
Date: 24 Apr 2006 11:31:39 -0700
Message-ID: <1145903499.332939.76780@v46g2000cwv.googlegroups.com>


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? Received on Mon Apr 24 2006 - 13:31:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US