If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

my god - what a load of rubbish, you cannot set transation like that!! all you are doing is supressing the error it gives

gee whizz

It does remove pending transaction even when commit or rollback force do not work .try it for yourself before calling it 'load of rubbish"

Under certain conditions, it may not be possible for an automatic recovery to execute without errors. As a result, recovery cannot identify it. (A possible symptom for this situation is when the ORA-02062 error is raised.) In this case, the DBA may use the DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure to clean up any entries whose state is not "prepared."

Last edited by BV1963; 07-09-2008 at 11:47 AM.

One, who thinks that the other one who thinks that know and does not know, does not know either!