Re: Grab current user name

Hello Rob!

Not clear enough?

declare
  My_Name Varchar2(60) := '';
begin
  My_Name := 'Actual User :' || user;
  ...
  My_Block.My_User_Field.Text := My_Name; (not sure if it's right!)   ...
end;

Stefan.

Rob <rrosenheim_at_my-deja.com> schrieb in im Newsbeitrag: 8qr0r7$d3n$1_at_nnrp1.deja.com...
> OK, I'm not that new at this. I know about retrieving the username
> from SQL*Plus. I need to know how to do it from a form using PL/SQL.
>
> rob
>
> In article <39ccd5ef.13947154_at_news.netvigator.com>,
> shanx_at_removethis_shanx.com (Shashank Tripathi) wrote:
> > Just type USER at the SQL*Plus prompt.
> >
> > sql> user
> >
> > Shanx.
> >
> > On Thu, 21 Sep 2000 19:29:55 GMT, Rob <rrosenheim_at_my-deja.com> wrote:
> >
> > | Good day all...
> > |
> > | I'm kind of new at this, so please bear with me. I'm developing
 a data
> > | entry form with Form Builder and need to capture the currently
 logged
> > | on user's username and insert it into a field in each record that
 is
> > | added by said user. Any help would be greatly appreciated, and
 please
> > | don't hesitate to be extremely explicit with your instructions.
> > | Thanks...
> > |
> > |
> > | Sent via Deja.com http://www.deja.com/
> > | Before you buy.
> >
> > --
> > It usually takes a long time to find a shorter way.
> >
> > Shashank Tripathi
> > http://shanx.com
> >
> >
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Sep 26 2000 - 16:50:52 CDT