ORA-02018 problem with closing dblink after data were selected

From: <jacek.wandycz_at_gmail.com>
Date: 22 Jun 2006 05:19:27 -0700
Message-ID: <1150978767.705522.69150@r2g2000cwb.googlegroups.com>

Hello,
I've got problem with dropping dblink after some data selection was executed,
simple workflow can be found below:
DBLINK1 is actually defined for local database link (here Oracle 9.2) and DBLINK2 for remote one
(Oracle 10.2). Even no data were selected I cannot drop database link for remote database within
current session - ORA-02018 always appears. Drop can be executed only if current session will be closed or from different connection.
Can you help me??

Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production

SQL> CREATE DATABASE LINK DBLINK1 CONNECT TO paris IDENTIFIED BY a USING 'PROM1'; Database link created.

SQL> CREATE DATABASE LINK DBLINK2 CONNECT TO paris IDENTIFIED BY a USING 'DEIMOS'; Database link created.

SQL> INSERT INTO TASK_INFO_at_DBLINK1(ID, PROJECT_ID, DESCRIPTION, CLASS_ID, INST_ID, USER_ID,
EXECUTION_DATE, INTERVAL, ISEXECUTED) SELECT ID, 1000, DESCRIPTION, CLASS_ID, INST_ID, USER_ID,
EXECUTION_DATE, INTERVAL, ISEXECUTED FROM TASK_INFO_at_DBLINK2 WHERE PROJECT_ID = 1640; 0 rows created.

SQL> COMMIT; Commit complete.

SQL> DROP DATABASE LINK DBLINK1; Database link dropped.

SQL> DROP DATABASE LINK DBLINK2;
DROP DATABASE LINK DBLINK2

                   *

ERROR at line 1:
ORA-02018: database link of same name has an open connection Received on Thu Jun 22 2006 - 07:19:27 CDT