Yeah,
I think (unfortunately) that to the db on the other side of the dblink, the
calling database is just like any other client
Jake
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA702DBC706_at_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 - 23:02:01 CST
