Re: userid in forms
From: Pete Hawdon <pete_at_hawdon.freeserve.co.uk>
Date: Sun, 19 Mar 2000 21:15:37 -0000
Message-ID: <8b3g1h$89g$1_at_news6.svr.pol.co.uk>
> __
>
> Jason Pepper - Enterprise Internet Tools Product Management
>
> __
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
> "Dave Briggs" <dave_briggs_at_my-deja.com> wrote in message
> news:8a8v6p$oq$1_at_nnrp1.deja.com...
> > How do I pull the userid that is using the form into a variable. Thanks
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Sun Mar 19 2000 - 22:15:37 CET
Date: Sun, 19 Mar 2000 21:15:37 -0000
Message-ID: <8b3g1h$89g$1_at_news6.svr.pol.co.uk>
why not just do :
message(USER);
you dont' need to select it from dual;
Jason Pepper <jpepper_at_uk.oracle.com> wrote in message
news:8ass9i$e8s$1_at_inet16.us.oracle.com...
> In a WNFI trigger
>
> declare
> l_user varchar2(32);
> BEGIN
> select userid into l_user from dual;
> message(l_user);
> end;
>
> --
> Regards
>
> Jason
>
>
> __
>
> Jason Pepper - Enterprise Internet Tools Product Management
>
> __
>
> Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
> "Dave Briggs" <dave_briggs_at_my-deja.com> wrote in message
> news:8a8v6p$oq$1_at_nnrp1.deja.com...
> > How do I pull the userid that is using the form into a variable. Thanks
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Sun Mar 19 2000 - 22:15:37 CET