Hi

I dont have a distributed databse scenario but still i see around 90 entries when i query

dba_2pc_pending


i have this procedure

Create or replace procedure rem_dist_locks

is

begin

for x in ( select local_tran_id from dba_2pc_pending )
loop
dbms_output.put_line( ' My variable is ' || x.local_tran_id );
execute immediate( ' commit force ''' || x.local_tran_id || '''' );
dbms_transaction.purge_lost_db_entry(x.local_tran_ id);
end loop;
end;

to remov the locks but my procedure hangs
what could be the problem with the database(817)

Rgrds