Autonomous transactions and 8.1.7

From: Mike Burden <michaelburden_at_capgemini.co.uk>
Date: Fri, 24 Aug 2001 09:24:49 +0100
Message-ID: <9m5307$c0b$1@taliesin2.netcom.net.uk>

Hi,

We've just upgraded to Oracle 8.1.7 and now I find that one of my PL/SQL procedure that uses an autonomous transactions falls over.

When executed from SQL plus it just disconnects from the database. No messages.

I've just started using this feature in 8.1.6 so I guessed this might be the problem. I commented out the AUTONOMOUS reference and the commit and it started to work.

Anyone else seen this problem.

Oracle Enterprise edition 8.1.7.0.0
SQLPlus 8.1.7.0.0

Example

SQL PS4 > exec devutil.polget('X','/CLEAR','BETA_GET') BEGIN devutil.polget('X','/CLEAR','BETA_GET'); END;

*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

SQL PS4 > Received on Fri Aug 24 2001 - 03:24:49 CDT