OraFAQ Forum: SQL & PL/SQL » sys_context for OS_USER returns null in Oracle SQL Dev

Home » SQL & PL/SQL » SQL & PL/SQL » sys_context for OS_USER returns null in Oracle SQL Dev

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sys_context for OS_USER returns null in Oracle SQL Dev [message #177147]

Tue, 13 June 2006 04:43

zodiac_hh
Messages: 10
Registered: June 2006

Junior Member

Hi there,

I have just discovered that

Code: [Select all] [Show/ hide]

sys_context('USERENV','OS_USER')

using SQL Developer (running on Windows XP) returns NULL. It works fine in SQLPlus and TOAD. Does anybody know what causes this behaviour and how to avoid it?

Report message to a moderator

Re: sys_context for OS_USER returns null in Oracle SQL Dev [message #177328 is a reply to message #177147]

Wed, 14 June 2006 03:46

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Well, I think the 'Why' is because SQL Developer is still as buggy as a thing that bugs like, that's been sprayed with bug attractant, and put in a field full of bugs.

It also fails to find the Terminal context, and gets the Host wrong (at least it does over here.

If you use Sql Developer, I'd put a post on their forum raising these points.

Report message to a moderator

Re: sys_context for OS_USER returns null in Oracle SQL Dev [message #177340 is a reply to message #177147]

Wed, 14 June 2006 04:29

zodiac_hh
Messages: 10
Registered: June 2006

Junior Member

I see what you mean. Found a posting on OTN regarding this topic, seems to be a bug that is allegedly fixed with the latest update, but it doesn't work here (v. 1.0.0.15.27).

http://forums.oracle.com/forums/thread.jspa?messageID=1178479&#1178479

I'm going to continue there.

Report message to a moderator

Previous Topic:	cursor.. loop - no data selected!!!
Next Topic:	tryky procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 03 13:25:01 CST 2025