title: How do I close the cursor created in a database link(ORA-02080)?
body: <p>I perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer:</p>
  
  <pre><code>create database link mydb connect to my_schema identified by mypwd using 'connection1';
  
  select * from users where id = 1;
  
  rollback;
  ALTER SESSION CLOSE DATABASE LINK mydb;
  drop database link mydb;
  </code></pre>
  
  <p>I get an error when I try to close the database link:</p>
  
  <blockquote>
    <p>SQL Error: ORA-02080: database link is in use
    02080. 00000 -  "database link is in use"</p>
    
    <p>*Cause:    a transaction is active or a cursor is open on the database link
               given in the alter session close database link  command.</p>
    
    <p>*Action:   commit or rollback, and close all cursors</p>
  </blockquote>
  
  <p>The transaction is finished, but when I do <code>select * from V$DBLINK;</code> I see there is still an open cursor, but I have no idea how I can close that one.</p>