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 -> Re: Oracle - Transactions !

Re: Oracle - Transactions !

From: Gert Rijs <gem_at_wirehub.nl>
Date: 1997/06/27
Message-ID: <01bc8343$3111aa20$0100007f@gertrijs>#1/1

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

Original text of this message

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