PL/SQL (MOSC)

MOSC Banner

ORA-02080: database link already in use

edited Dec 4, 2018 1:20PM in PL/SQL (MOSC) 8 commentsAnswered
Hi,

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:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center