APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

closing a database link within an apex page

312410Oct 30 2009 — edited Oct 30 2009

Hi all,

I'm considering using database links to allow Oracle APEX to connect to a few remote database instances, including non-oracle ones.

I wanted to test whether explicitly closing database links with ALTER SESSION CLOSE DATABASE LINK linkname would help manage the open links within the instance.

Thus far in the prototype of the application (primarily a reporting app with very little DML) all the links are in the source of reports and charts.

How would I go about explicitly closing a database link with the statement above? Where would I place the code?

I'm running Apex 3.2.1/ Oracle database 11.1.0.7.0 / Windows 2003.

thanks,
Ben
http://dbbulletin.wordpress.com

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 27 2009

Added on Oct 30 2009

#11g, #apex, #apex-discussions, #windows

2 comments

740 views