Re: calling program

2002-03-15 Thread Big Planet
Thanks all for your help . I got the answer .   Big P   - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, March 15, 2002 1:49 PM Subject: Re: calling program Not exactly true...   Well, since original question

RE: calling program

2002-03-15 Thread Jack C. Applewhite
Ouch! Looks like I need to RTFM, not only before asking a question, but before answering one - "shoot from the hip" = "shot in the foot". 8-( Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [

Re: calling program

2002-03-15 Thread Igor Neyman
just anonymous blocks). Check the docs on DBMS_UTILITY..FORMAT_CALL_STACK.   Igor Neyman, OCP DBA[EMAIL PROTECTED]  - Original Message - From: Jack C. Applewhite To: Multiple recipients of list ORACLE-L Sent: Friday, March 15, 2002 4:23 PM Subject: RE: calling pr

RE: calling program

2002-03-15 Thread Ron Thomas
MAIL PROTECTED] Sent by:cc:

RE: calling program

2002-03-15 Thread Jamadagni, Rajendra
Actually you can, dbms_utility.format_call_stack, but you'll have to parse the information. See http://osi.oracle.com/~tkyte/who_called_me/index.html Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com An

RE: calling program

2002-03-15 Thread Jack C. Applewhite
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, J