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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Autonomous transactions and 8.1.7

Re: Autonomous transactions and 8.1.7

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 24 Aug 2001 10:10:34 +0100
Message-ID: <3B861A0A.4D93@yahoo.com>


Mike Burden wrote:
>
> 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 >
No but it wouldn't surprise me - other things like using auto txns in a fetch-for-update cursor also had little nasties as well.

I'd seriously have a look at going to patch 8.1.7.2

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
Received on Fri Aug 24 2001 - 04:10:34 CDT

Original text of this message

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