Oracle Forms

Hiya

As part of the user authentication in our application, the requirement is that if a user has logged in from one machine, the same user cannnot login from different machine at the same time.

In Forms6i, we had accomplished this using the following query:

Select Terminal
From v$session
Where username = v_username
And terminal <> v_terminal;

Where
v_username = USER -> Oracle Forms Reserve Word
v_terminal = Client_Win_API_Environment.Get_Windows_Username

In Forms 6i, the Terminal column of V$Session used to return the name of the local client machine.

However, in Forms 10g, it returns the machine name on which Oracle Application Server is installed, which I believe is correct.

So my question is how do we get the client machine name from database in the context of Oracle Forms 10g ? Is there another view/table or database package that returns the client machine name ?

Your suggestions/comments will be much appreciated.

Cheers

Mayur