after commiting the transaction i am able to insert.
but the same error is comming again...So what steps i can take for stoping it :)
I think it is the problem with the aplication ?

07-09-2008, 11:12 AM

BV1963

Quote:

Originally Posted by davey23uk

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."

07-09-2008, 11:58 AM

gandolf989

Quote:

Originally Posted by BV1963

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

Perhaps changing the process would stop this error from occurring. This just looks like a kludge to keep bad code running.

07-10-2008, 02:07 AM

gopu_g

Quote:

Originally Posted by gandolf989

Perhaps changing the process would stop this error from occurring. This just looks like a kludge to keep bad code running.

needs some alteration in the code :)

07-10-2008, 03:11 AM

gopu_g

please let me know why the transaction is pending,how to find where it is blocking.How to check which query is performing when the state of transaction
is prepared