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 -> Sub-Transaction within PL/SQL

Sub-Transaction within PL/SQL

From: N. Dirks <ndirks_at_sundn.de>
Date: 1998/01/27
Message-ID: <34CE096C.7215@sundn.de>#1/1 







Hi,



for an Oracle PL/SQL-Project it would be fine
to create sub-transactions within PL/SQL-



These sub-transactions would be responsible
for logging method-irregularities (Errors, Exceptions,
hurt privileges, etc.) into a special loggingtable
 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 ?



Thanks


 Nico Dirks
Received on Tue Jan 27 1998 - 00:00:00 CST












Original text of this message













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