Re: Database link

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 15 Mar 2002 14:47:33 GMT
Message-ID: <a6t1i5$9rq$1@news.liv.ac.uk>

,Juha Leinonen <juhal_at_nospamiki.fi> wrote:
: Is there any way to disconnect session which is established thorough
: database link.

: I have database A where is package which transfers some data to
: database B through database link. But it leaves the session open to
: database B. How to force the package to disconnect the session after
: execution.

: Thanks,
: Juha Leinonen

alter session close database link <linkname>;

might be what you are looking for.

HTH Helen Received on Fri Mar 15 2002 - 08:47:33 CST