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, 18 Mar
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
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