2

I have a DB link between 2 Oracle databases, and I have a procedure which in some cases it can query the remote database.

Now the docs say that a connection is opened per session when it appears in an SP, and my question is will it establish the connection when a statement has occured or since it appears in the compiled SP it will establish it once a call has been made to the procedure?

eric.itzhak
  • 15,752
  • 26
  • 89
  • 142

1 Answers1

0

The dblink is used during the compilation for a first time. When you call your sp the db link will create the connection and close the connection after you exit your session.

Yuri Levinsky
  • 1,515
  • 2
  • 13
  • 26