ORA-02080: database link already in use
i have two databases db1 and db2. On db1 i have a procedure that inside it contain a cicly that call a procedure locate on db2.
the procedure on the db2 open a cursor and load a set of records into a table on DB1.
when the procedure on db1 executed it return the following error: ORA-02080: database link already in use 18/09/2012 10.47.28
this is the interessed part of procedure on DB1:
for y in cur_tt_chiusi loop
PRC_AAAA_ON_DB1@LINK_DB2(y.identificativo_tt,v_id_caricamento);
end loop;
this is the interessed part of procedure on DB2: