RE: Remote Sequence is not releasing the connection

Database links remain open until the client session closes them or until the client session exits.
You can use:
Alter session close database link 'link_name';

You must commit or rollback before closing the link. Otherwise you cannot close it.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Subbiah, Nagarajan Sent: Wednesday, February 09, 2005 12:29 AM To: 'oracle-l_at_freelists.org'
Subject: Remote Sequence is not releasing the connection

We have a synonym in local database for a sequence, which is in remote database. After selecting the nextval from the local database, there is a
session opened in the remote database but not closing the session after the
'select' is completed. . We are at HP11.11 and Oracle 9.2.0.5. Over the period of time, it gives the "ORA-01000 number of open cursors exceeded" error. Open cursors value was increased to triple the value but still the
problem persists. Any idea is this a bug or missing any configuration. If
the synonym is dropped and actual sequence is created in the local database,
then there are no issues.
=20

Raja
Ph: (212) 210 1461
=20

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l