Big Planet,
 
Whoa, now there's a can of worms!
 
In a word - no.  Not unless you pass that info. in as an argument.
 
Think about what you're asking.  Since PL/SQL procedures can be called from, not only other PL/SQL procedures and functions, but the SQL*Plus command line, ODBC calls, Java programs, etc. etc., what would be the identification mechanism?
 
Also, since PL/SQL functions can be embedded in SQL statements, there's yet another problem - how does a SQL statement know/report what program is using it?
 
The overhead to give you what you're asking would, IMHO, be too high if provided by the PL/SQL engine.
 
Jack

--------------------------------
Jack C. Applewhite
Database Administrator/Developer
OCP Oracle8 DBA
iNetProfit, Inc.
Austin, Texas
www.iNetProfit.com
[EMAIL PROTECTED]
(512)327-9068

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Big Planet
Sent: Friday, March 15, 2002 2:18 PM
To: Multiple recipients of list ORACLE-L
Subject: calling program

Hi LIst ,
Is there a way a pl/sql procedureor function  can know the calling procedure or calling program .
-ak
 
 
 

Reply via email to