-- how to check if database link is active

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Andre
    #1

    -- 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
    Tags: None
    • 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

        Previous template Next
        Working...