Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sub-Transaction within PL/SQL
One possible work-around is to have another session going for your subtransactions. What you do: look at the information on DBMS_PIPE in the Application Developer's Guide. See the sample code for a Pro*C daemon to execute system (host) commands? Well, you could write a similar daemon that is listening on a pipe for commands to run on behalf of another session. When the daemon commits, it is committing its own logical unit of work, not that of the session that sent requests over the pipe.
Matthias Gresz <GreMa_at_t-online.de> wrote in article
<6akrhn$4fn$1_at_news01.btx.dtag.de>...
> Hi Nico,
>
> some weeks ago we had the same wish and discussed with german support if
> and how it could be done. NO CHANCE! COMMIT commits all!
>
> N. Dirks wrote:
> >
> > Hi,
> >
> > for an Oracle PL/SQL-Project it would be fine
> > to create sub-transactions within PL/SQL-
> > Methods.
> > These sub-transactions would be responsible
> > for logging method-irregularities (Errors, Exceptions,
> > hurt privileges, etc.) into a special logging-
> > table and commiting these INSERTS without
> > affecting the state of our main-transaction
> > (without COMMIT !!!! on our main-transaction).
> >
> > Is it possible to create a sub-transaction
> > within PL/SQL-Methods ? And how do I create them ?
Received on Fri Jan 30 1998 - 00:00:00 CST