Skip to Content
0

How to close DBlink session in sap using code

Jul 24, 2017 at 03:48 PM

73

avatar image
Former Member

Hi All,

I am facing issue in sap while using Dblink. sessions not getting closed..

we are using Dblink tables to get the data from External oracle database and when we use Select query the Dblink session is getting opened and its in active mode but after extracting data from table still its in inactive state. session not getting closed .

so, what will be the issue and how to resolve this issue.

regards,

Vinod

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Horst Keller
Jul 25, 2017 at 04:54 PM
0
Share
10 |10000 characters needed characters left characters exceeded
David Antonio Arroyo León Jul 25, 2017 at 04:23 PM
0

Hi Vinod,

Check SAP Note 25383 - Database links, synonyms, remote DB.

Oracle recommends to use "ALTER SESSION CLOSE DATABASE LINK linkname;"

Regards,

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Sep 07, 2017 at 09:44 AM
0

thanks David,

The above syntax is to close the connection for Native SQL.

can you please let me know how to close for open SQL statements,

Regards,

Vinod.

Share
10 |10000 characters needed characters left characters exceeded