database links, remote sessions

From: steph <stephan0h_at_yahoo.de>
Date: Thu, 11 Sep 2008 04:54:32 -0700 (PDT)
Message-ID: <d15f829c-2e59-451c-8648-22b1a400f90e@c58g2000hsc.googlegroups.com>


Hi group,

A question regarding Oracle 10G:

I understand that when using database links a session is opened at the remote server which stays alive until the local session is closed or the database link is closed explicitly.

Does this mean, that I can rely on the fact, that the remote session will stay the same for as long as my local session lives? For instance when I set package variables at the remote site do they stay valid until I close my local session?

Thanks,
Stephan Received on Thu Sep 11 2008 - 06:54:32 CDT

Original text of this message