Re: Nested Transactions?

Hi Korey,

You need to trap your exceptions in your pl/sql code, like this exception
when others then
sqlstr := dbms_utility.format_error_stack||' '||dbms_utility.format_call_stack);
rollback;
insert int to eventlog values (sysdate, sqlstr) end;

etc.

Hth,

Sybrand Bakker, Oracle DBA

Korey Sed <korey_sed_at_yahoo.com> wrote in message news:7pk1rq$qje8_at_mascagni.pfizer.com...
> Is it possible to have nested transactions or a similar thing in Oracle
> 7.3.2?
>
> We want to be able to log any errors from an oracle job into a table, but
> right now if the job fails everything gets rolled back, so we have no
trace
> of what happened!
>
> Thanks
> Korey
>
>
Received on Fri Aug 20 1999 - 12:47:42 CDT