I'm running a PL/SQL procedure to insert some values to a table in another database using DBLINK. My PL/SQL procedure uses Commit and then Alter Session Close Database Link commands. However, sometimes I got ORA-02080 errors. The database link being used is not used by any other process I know. One more thing, the database link mentioned is based on Oracle Gateway to Sybase. In other words, other database is actually "Sybase".
Could you please help me.