Re: Help! How do we track SQL's in a trigger.

In <01bc3a30$a4673640$a10b0514@rram.den.csci.csc.com>, ram wrote: }Hi, } I am new to triggers and stored procedure. what I found was that }triggers and stored procedures don't get written into the sqexplain.out }file. I watch this file for potential performance issue. Since we choose to }go the trigger and stored procedure way I am looking for ways to track }queries that run during a process. ANY Help is appreciated } }Thanks }Ramesh } }Email Address is rramesh@csci.csc.com. I had to change it as I started }getting lot of junk mail. I would advice Everybody do that as it is getting }very annoying nowadays } } Ramesh, Use TRACE ON / OFF / PROCEDURE / SPL-Expression in your stored procedure. Cheers Felix K. Mathews (fmathews@systems.dhl.com)