Re: Username in PL/SQL

declare
  username varchar2(30);
  var function_return_type;
begin
  select USER into variable from DUAL;
  var := function_name(variable);
end;

metalocasnica

• Original Message ----- From: Edward Beemer <ebeemer_at_tas.nl> To: <comp.databases.oracle.misc_at_list.deja.com> Sent: Thursday, August 26, 1999 10:17 AM Subject: Username in PL/SQL

> Message from the Deja.com forum:
> comp.databases.oracle.misc
> Your subscription is set to individual email delivery
> >
> Hello guys,
>
> How can I use the username of the currently logged on user in a PL/SQL
> function?
>
> I would like to call some function with the current username as a
parameter.
>
> With kind regards,
> Edward Beemer
>
>
>
>
>
> _____________________________________________________________
> Deja.com: Share what you know. Learn what you don't.
> http://www.deja.com/
> * To modify or remove your subscription, go to
> http://www.deja.com/edit_sub.xp?group=comp.databases.oracle.misc
> * Read this thread at
> http://www.deja.com/thread/%3C7q2pr6%24ibs%241%40zonnetje.nl.uu.net%3E
>

 Sent via Deja.com http://www.deja.com/  Share what you know. Learn what you don't. Received on Thu Aug 26 1999 - 06:24:28 CDT