Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle - Transactions !
Zoran Ivanovich <zorani_at_waldonet.net.mt> wrote in article
<33B39ACF.67E3_at_waldonet.net.mt>...
> Hi,
<snip>
>
> But, we need, from time to time, to update few tables with current log
> information, security, sequence numbers, … All this should run as
> parallel transaction, or as nested transaction.
>
> Is there any way to have this functionality (within PL/SQL), something
> like:
>
> - SQL INSERT/UPDATE not associated with any transaction,
> - or opening another session which will have parallel transaction
> capability
> - nested transaction, within the same session
> - accessing some global table
> - or something else (???)
>
you could use savepoints for this. Something like
begin
hope this helps,
Gert Received on Fri Jun 27 1997 - 00:00:00 CDT