Chuan,
If I remember right, you're supposed to turn the outlines on and then run your sikvel or procedure to catch the offensive statement(s). Regards, Ed > > Hi, All, > From Oracle Doc: "if the SQL text of the incoming statement > exactly matches the SQL text in an outline in that category, > then Oracle considers both texts identical, and Oracle uses > the outline. Oracle considers any differences a mismatch." > > How could I ensure the incoming SQL text exactly match the > SQL text in an outline? If I fish out an offensive SQL from > library cache by some scripts in SQL*Plus, is this offensive > SQL text identical to the incoming SQL text? Supposed this > SQL text is extracted from stored procedure. > > Appreciated your experience. > > Chuan > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
