Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Why we should use bind variables when we write code......
Mark,
Basically Oracle "tries" to share SQL statements all the time. So when it gets a new SQL statement, it first creates a checksum and compares that checksum with each of the SQL statements in the buffer to try to find a match, an exercise in futility with non-binding code. Here is what I did when I encountered your problem a few years ago, maybe others have better suggestions:
That should get you past the crisis. Then you can work the larger issue of training all the developers.
Dennis Williams
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Sep 19 2006 - 18:24:41 CDT
![]() |
![]() |