MDAC 2.6 MSDAORA driver is supposed to translate the ADO parameter markers
defined by '?' into Oracle bind variables (i.e. ":V001"). However it
appears NUMERIC type parameters are not always being translated to bind
variables (the literal is being passed over to Oracle (VARCHAR2 are OK)).
This is not allowing Oracle to reuse the queries in the SGA resulting in
excessive hard parses. Does the latest MDAC (2.7 or subsequent 2.6 patches)
fix this issue ?

Ashish Viradia.
Database Administration
MS Sql Server LazyDBA home page