Kbase P99404: Error ORA-2080 when issuing a 'ALTER SESSION CLOSE DATABASE LINK'
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
SYMPTOM(s):
RUN STORED-PROC send-sql-statement ("ALTER SESSION CLOSE DATABASE LINK <dblink>").
Error ORA-2080 database link in use
CAUSE:
The cursor(s) which accessed the remote Oracle Database have not been closed.
FIX:
Make sure all cursors accessing the remote Oracle database have been closed prior to running the CLOSE DATABASE LINK.