Who's calling who??

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Wed, 30 Oct 2002 15:14:56 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702DBC706@lnewton.leeds.lfs.co.uk>

Hi Jake,

I could be miles off again, but ..........

I think you are up that creek as far as grabbing some sort of sys_context stuff is concerned - after all, when you created the db link to db3 you did something like 'create database link connect to user identified by password...' so, when you select from the remoptetable_at_db3, there will be a connection to that user on db3. Grabbing the stuff from sys_context will relate to that connection I would expect and not to the one on the calling machine.

cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Jake [mailto:me_at_heyjay.com]
Posted At: Wednesday, October 30, 2002 2:01 PM Posted To: server
Conversation: Who's calling who??
Subject: Re: Who's calling who??

Come on you guys, can't anyone answer this? Sybrand, Richard, Howard, Niall, et al

here's a better picture (for some reason my ascii art had \n's):

     Box1            Box2
     ----            ----

c1-- db1 --dblink-- db3
c2-- db2 --dblink --/ Received on Wed Oct 30 2002 - 09:14:56 CST