Declare
Var1 varchar(20);
Begin
Select user into var from dual;
End;
Why making it complicated ?
Rochak Agrawal| DBA | Tech Mahindra
-----Original Message-----
From: Ephraim V Malag [mailto:oracledba-ezmlmshield-x7648836.[Email address protected]
Sent: Wednesday, September 05, 2007 4:43 PM
To: LazyDBA Discussion
Subject: Re: Current login
select a.username, b.* from v$session a, v$access b
where a.sid=b.sid;
"Шатыр Дан Юрьевич "
<oracledba-ezmlmshield-x39723031.[Email address protected] wrote on
09/05/2007 07:02:36 AM:
> Hello
>
> Please point me the way to find out which is the current user name
> in my PL/SQL procedure. ( I mean, who calls my procedure)
>
> Thanks for your help,
> Dan.
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
---
This e-mail may contain confidential and/or privileged information. If you
are not the intended recipient (or have received this e-mail in error)
please notify the sender immediately and destroy this e-mail. Any
unauthorized copying, disclosure or distribution of the material in this
e-mail is strictly forbidden.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
============================================================================================================================
Disclaimer:
This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.
============================================================================================================================
Oracle LazyDBA home page