Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> In doubt distributed transactions
Hi,
I try to :
execute dbms_transaction.purge_lost_db_entry(global_txn_id);
if i execute it using sys user I get the following error : ERROR at line 1:
ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "SYS.DBMS_TRANSACTION", line 94 ORA-06512: at line 1
if i execute it using system user i get different error : ERROR at line 1:
ORA-00942: table or view does not exist ORA-06512: at "SYS.DBMS_TRANSACTION", line 86 ORA-06512: at line 1
what's wrong ? any ideas ?
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 02:03:41 CST