From: kennedy-downwithspammersfamily@attbi.net   
      
   "CM"  wrote in message   
   news:c157o9$k02@aix4.segi.ulg.ac.be...   
   > Hello,   
   >   
   > Is it possible to create a transaction in a transaction?   
   >   
   > BEGIN T1   
   >   
   >     INSERT into t1 values(2);   
   >   
   >     BEGIN T2   
   >   
   >         INSERT into t1 values(3);   
   >   
   >     ROLLBACK T2   
   >   
   > COMMIT T1   
   >   
   > I will have liked that the "ROLLBACK" of the T2 transaction   
   > does not disturb the "INSERT" made in the principal transaction.   
   > If that exists, which are commands SQL for Oracle 9i?  Thank you very   
   much.   
   > (And excuse me for my imperfect English)   
   >   
   > Christophe   
   >   
   >   
   Look up savepoint in the docs.   
   Jim   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)