ORACLE 8.1.7 FAILS WITH RETURNING CLAUSE UNDER XA..

From: Frederick Isaac <FreddyIsaac_at_yahoo.com>
Date: 11 Jun 2001 22:16:36 -0700
Message-ID: <5e2a8dac.0106112116.5e7c24dd_at_posting.google.com>


Hi,

Am working with oracle 8.1.7 under Dynix (although if this is a real problem it probably happens elsewhere). We have Tuxedo 6.5 running under windows 2000. The problem comes with using the RETURNING clause during INSERT, UPDATE or DELETEs. Oracle fails with an ORA-65534 error. (an undocumented error!). The same code workis without the RETURNING clause.

Does anyone know of any reason why this should happen. Does the RETURNING clause work under 8.1.6 or any other version alongside XA, or is this a limitation of the Oracle RM/OCI implementation.

Thx in advance

Freddy Received on Tue Jun 12 2001 - 07:16:36 CEST

Original text of this message