-- how to check if database link is active

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Andre

    -- how to check if database link is active

    Hello all,

    How can I check (within a pl/sql-procedure) if a database link is active or not??
    I am using oracle 8.1.7

    Thanks and regards,
    Andre van Rossem
  • Jusung Yang

    #2
    Re: -- how to check if database link is active

    avanrossem@hotm ail.com (Andre) wrote in message news:<4d32d1be. 0307102214.74ab 96e5@posting.go ogle.com>...[color=blue]
    > Hello all,
    >
    > How can I check (within a pl/sql-procedure) if a database link is active or not??
    > I am using oracle 8.1.7
    >
    > Thanks and regards,
    > Andre van Rossem[/color]

    Look up v_$dblink. Make sure you can select from it within the stored
    procedure though.


    - Jusung yang

    Comment

    Working...