Re: transactions and stored procedures

From: Lothar Armbrüster <lothar.armbruester_at_rheingau.netsurf.de>
Date: 22 Feb 99 23:33:00 +0100
Message-ID: <435.722T37T14132568@rheingau.netsurf.de>

On 22-Feb-99 21:58:57 Kent Eilers wrote:

>Can Oracle transactions span stored procedures? By this I mean having
>several stored procedures as part of one transaction.

Yes, they can, unless the procedures themselves do commit or DDL statements (via dynamic SQL).

>thanks.

Lothar

Lothar Armbrüster       | lothar.armbruester_at_rheingau.netsurf.de
Schulstr. 12            | lothar.armbruester_at_t-online.de
D-65375 Oestrich-Winkel |

Received on Mon Feb 22 1999 - 16:33:00 CST