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

 
Received on Thu Sep 06 2001 - 17:02:47 CDT