How to close DBlink session in sap using code

[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

[Former Member]

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.

[horst_keller]

https://blogs.sap.com/2017/06/27/database-connections-prepublished/

[former_member235395]

Hi Vinod,

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

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

Regards,