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 -> Multiple independent transaction handle by a stored procedure

Multiple independent transaction handle by a stored procedure

From: Bjørn Dybdal <bd_at_datani.dk>
Date: Tue, 3 Nov 1998 16:59:15 +0100
Message-ID: <71n98k$9rt$1@miri.tele.dk>


Does anybody know a way to handle multiple independent transactions inside a stored procedure.

My problem is that I have to do some update in my database. If I encounter problems during my processing
I want log these problems in a seperate table XX. If my updating process ends out with a rollback I don't want my logging into table XX to be rolled back.

Med venlig hilsen
Bjørn Dybdal
Datani A/S
Hørkær 12A
2730 Herlev
Tlf: 44 53 41 44
mailto:bd_at_datani.dk Received on Tue Nov 03 1998 - 09:59:15 CST

Original text of this message

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