Selecting a global user

[Kido]

In 6i, am able to select the global user as:

select <field> into <variable> from <table>
where <field>= upperglobal.sysuser);

but when i try the same in 9i i get the message 'no data'.

Anyone with a solution?

 

[SantaMufasa]

Kido,

Sorry for my density on this, but what is "6i"? Also, in my 17 years using Oracle, I don't recall encountering anything called ":global.sysuser". Could you please elaborate?

Mufasa
(aka Dave of Sandy, Utah, USA)

http://www.dasages.com

Do you use Oracle and live or work in Utah, USA?
Then click here to join Utah Oracle Users Group on Tek-Tips.

 

[Kido]

Sorry I meant Oracle developer 6i and am trying to get the application user as in the user who is currently logged on to the application

 

[Kido]

The solution is simply getting the application property for the user!!!

<Variable>:= Get_Application_Property(USERNAME);