home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 1,126 of 2,288   
   CM to All   
   under-transaction ?   
   20 Feb 04 16:05:47   
   
   From: le-spam-je-dis-non@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca