Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Sub-Transaction within PL/SQL
Hi Nico,
some weeks ago we had the same wish and discussed with german support if and how it could be done. NO CHANCE! COMMIT commits all!
N. Dirks wrote:
>
> Hi,
>
> for an Oracle PL/SQL-Project it would be fine
> to create sub-transactions within PL/SQL-
> Methods.
> These sub-transactions would be responsible
> for logging method-irregularities (Errors, Exceptions,
> hurt privileges, etc.) into a special logging-
> table 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
-- Regards Matthias Gresz :-)Received on Tue Jan 27 1998 - 00:00:00 CST