Skip to Content
avatar image
Former Member

How to close DBlink session in sap using code

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 25, 2017 at 04:54 PM
    Add comment
    10|10000 characters needed characters exceeded

  • Jul 25, 2017 at 04:23 PM

    Hi Vinod,

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

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

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 07, 2017 at 09:44 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded