Database Security Products (MOSC)

MOSC Banner

select sys_context('USERENV','HOST') from dual is null

edited Oct 8, 2009 7:15PM in Database Security Products (MOSC) 12 commentsAnswered
 Hi All,

When I run: select sys_context('USERENV','HOST') from dual; from my computer(including Toad and sqlplus), I got Null value. But When I use putty connect to database server and run this SQL, I got the host name. My co-worker, his computer is in the same network with me, and when he ran this SQL from his computer, he can get host name. Anybody know how to figure out this?

Thanks a lot,

kelivn 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center