Re: Nested Transactions?

It is possible to do this even in the 7.x .

what you need to do is use a 'database identifier ' get two connections to the database

in pro*c :

// remember, these are connections to the same database , just tso different // identifiers
exec sql connect :username identified by :password at db_name1

exec sql connect :username identified by :password at db_name2

exec sql insert into table_at_db_name1 values(......);

exec sql insert into table_at_db_name2 values(......);

commit_at_db_name2 or rollback_at_db_name2 // this commits or rolls back only statement 2.

based on statement 2's outcome you can do whatever you wish with statement1.

Kary Kalapanda.

doeni_at_kheldar.evhr.net wrote:

> "Korey Sed" <korey_sed_at_yahoo.com> writes:
>
> This feature has been implemented in Oracle 8.1.5
>
> > 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 27 1999 - 12:20:10 CDT