OraFAQ Forum: Forms » How to do this ( plz give a look )

Home » Developer & Programmer » Forms » How to do this ( plz give a look )

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

How to do this ( plz give a look ) [message #83914]

Wed, 31 December 2003 06:23

nisha
Messages: 14
Registered: February 2002

Junior Member

well how can i get System username, terminal name and date of Application in my form to collect the data about the user which use the application of Developer and plz also give me assisstance about how to embed Flash .swf movie in the forms 6.0
Thanx and Regards,

Report message to a moderator

Re: How to do this ( plz give a look ) [message #83922 is a reply to message #83914]

Mon, 05 January 2004 22:35

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Session details can be found in v$session, and code like:

Declare
  v_user Varchar2(250);
  v_term Varchar2(250);
Begin
  Select osuser
       , terminal
    Into v_user
       , v_term
    From v$session
<B>   Where audsid = userenv('sessionid');</B>
...
...
End;

can do the trick.
But in a Windows environment, you could make use of the D2KWUTIL.PLL library. This can be found in the ORACLE_HOMETOOLSDEVDEM60DEMOFORMS directory. Take a look at the WIN_API_ENVIRONMENT package, which enables you to read system variables and the registry.

MHE

Report message to a moderator