One possible way would be to have your package make
calls to dbms_application_info.set_client_info. The
other session could then read v$session to see who is
running it.
hth
connor
- ayyappan.subramaniyan_at_ssiworldwide.com wrote: >
Hi
>
> I am having one package which I have created.
> If I an executing that package on one session and in
> another session
> I want to know the Process of the package is running
> with the package name.
> How to Know that?.
>
> Regards
> Ayyappan.S
>
>
> This communication contains information, which is
> confidential and may also
> be privileged. It is for the exclusive use of the
> intended recipient(s). If
> you are not the intended recipient(s), please note
> that any distribution,
> printing, copying or use of this communication or
> the information in it is
> strictly prohibited. If you have received this
> communication in error,
> please notify the sender immediately and then
> destroy any copies of it.
> Visit us @
>
www.ssiworldwide.com********************************************************
> ********************
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author:
> INET: ayyappan.subramaniyan_at_ssiworldwide.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)
"Some days you're the pigeon, some days you're the statue"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Mar 19 2002 - 07:08:22 CST
