Page 1 of 1
Using bind variable
Posted: Tue 30 Nov 2004 17:57
by Ping Kam
If I remember correctly, ODAc 4 will modify my sql and replace all static values to bind variables (I saw this in the SQLMonitor and DBMonitor). Now ODAC 5 doesn't do that anymore (from what I see in the SQLMonitor and DBMonitor). Am I correct? Any reason for such change?
Posted: Thu 02 Dec 2004 07:36
by Paul
No, ODAC passes parameters as bind variables. It does not modify SQL during
processing it on Oracle server and in SQLMonitor, DBMonitor. DBMonitor shows
SQL query as it was executed on Oracle server. Please check ODAC 4 again.
Posted: Thu 02 Dec 2004 16:12
by Ping Kam
Sorry if I don't make it clear the first time. I didn't mean that ODAC changes parameters to value, but the other way round in ODAC 4.
I may be wrong but from what I remember, ODAC 4 will replace the values in the where clauses with bind variables. Now I have changed to ODAC5 and don't have ODAC4 installed anymore. I will re-install ODAC4 to check it out when I have a chance.