Ayyappan,
You can use the procedures in DBMS_APPLICATION_INFO to publish and
interrogate the states and actions of modules.
Jack
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTE
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
--- [EMAIL PROTECTED] wrote: >
Hi
>
> I am having one package which I have created.
> If I an executing that pa
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
I am not sure that I understand what you mean, but check for DBMS_JOB in the 'PL/SQL
supplied packages' manual (or read dbmsjob.sql under $ORACLE_HOME/rdbms/admin).
>- Original Message -
>From: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L
><[EMAIL PROTECTED]>
>Sent: Mon, 1