Re: Please help

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Fri, 01 Oct 1999 10:26:41 -0700
Message-ID: <37F4EED1.86D8059A@vnl.nl>

tarik wrote:

> Hi everybody
>
> I am to create a screen in Forms 5.0 where at the top of the screen I need
> to show the current user's name and the the login time in a dispaly item.
>
> Can any one please tell me how to get the current user's name in the display
> item ( using what system variable, how and on which trigger at what level )
>
> Thanks for your help
>
> Tarik

You could use the on-logon trigger to capture username. Or do select user from dual, and store that in a global variable. Pre-form trigger would
be the place then. At the same time, capture the time into a global.

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
V&L Informatica BV                   Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Fri Oct 01 1999 - 12:26:41 CDT