In doubt distributed transactions

From: <yewpc_at_my-dejanews.com>
Date: Fri, 12 Mar 1999 08:03:41 GMT
Message-ID: <7cahop$o0g$1@nnrp1.dejanews.com>

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