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
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
[
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
MAIL PROTECTED]
Sent by:cc:
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
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