From bing.wong@IngramMicro.com Thu, 06 Sep 2001 15:54:28 -0700 From: "Wong, Bing" Date: Thu, 06 Sep 2001 15:54:28 -0700 Subject: RE: Egregious coding Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: Egregious coding I think it is best to escalate this to management to deal with bad SQL coding.  May be your shop needs SQL coding standard?     -----Original Message-----From: Hagedorn, Linda [mailto:lindah@epocrates.com]Sent: Thursday, September 06, 2001 4:06 PMTo: Multiple recipients of list ORACLE-LSubject: Egregious coding Has anyone thought of a clever way to fail every SQL statement that does not use a bind variable that I could switch on and off as required?       I'm looking at hundreds of thousands of queries in the v$sqlarea in production.  I've taken engineering management to task over this, and have gotten empty promises in return.  I would love to hold a valid threat over their heads that I'm going to shut off every statement that is not coded properly.  Any ideas are appreciated. Linda