Yes, But how could I ensure offensive statements in outline exactly
matching the incoming statements?
Thanks
CHuan
-Original Message-
Sent: Tuesday, 10 September 2002 6:58 PM
To: Multiple recipients of list ORACLE-L
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).
Unless otherwise stated, this e-mail does not represent the views of
TransACT Communications Pty Limited. This text and any attachments of
this e-mail are confidential and may be legally privileged. This email
is for the use of the intended recipient only. If you are not the intended
recipient do not take any action in relation to this email, other than to
notify TransACT Communications by replying to this e-mail and destroying
the original communication. Except as required by law, TransACT
Communications does not represent that this transmission is free of errors,
viruses or interference.