RE: How to Trace PL/SQL

From: James McCann <james_at_openet-telecom.com>
Date: Tue, 08 Jan 2002 04:20:41 -0800
Message-ID: <F001.003E959B.20020108035549@fatcity.com>

Use DBMS_PROFILER.

It might have what your looking for,

Jim

-----Original Message-----

Sent: 07 January 2002 20:11
To: Multiple recipients of list ORACLE-L

Is there a way to trace the SQL executed by a PL/SQL program (i.e. stored procedure)? Using
DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION... does not seem to work when the session is calling a stored procedure.

I'm running 8.1.7.2 on Solaris 2.8.

Thanks.
-w

Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Walter K
INET: alden14004_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message

to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: James McCann
INET: james_at_openet-telecom.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists


--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message