Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to recover a transaction in prepared state usign OCI functions?

Re: How to recover a transaction in prepared state usign OCI functions?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 13 Jul 2006 07:34:31 -0700
Message-ID: <1152801271.051433.154260@35g2000cwc.googlegroups.com>

sfama wrote:
> Hi!
>
> I see there are transaction OCI function how OCITransCommit() etc.
> Is there an OCI function that recover that transaction that are in
> prepared state and that I can find into DBA_2PC_PENDING table?
>
>
> Thank you!

Is there a reason you have to use OCI calls rather than the Oracle provided procedures in DBMS_TRANSACTION to commit, rollback, or purge pending transactions?

HTH -- Mark D Powell -- Received on Thu Jul 13 2006 - 09:34:31 CDT

Original text of this message

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