SYS_CONTEXT DBLINK_INFO returns null over db link

From: Rich Jesse <rjoralist3_at_society.servebeer.com>
Date: Mon, 3 Mar 2014 11:22:25 -0600 (CST)
Message-ID: <a1b17773ea60282abf2dfeb9659c90bd.squirrel_at_society.servebeer.com>



Hey all,

In 11.2.0.3, I'm trying to determine where a query over a dblink originated using:

SELECT
        SYS_CONTEXT('USERENV','DBLINK_INFO')
FROM DUAL_at_REMDB;

...but it always returns a NULL. This is documented at:

http://docs.oracle.com/cd/E11882_01/server.112/e26088/functions184.htm

Anyone know where else I could get this info? Well, other than X$ tables as specified in:
http://jkstill.blogspot.com/2010/03/whos-using-database-link.html Not sure I want to go there if'n I don't have to...

TIA! Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Mar 03 2014 - 18:22:25 CET

Original text of this message