Using bind variable

Ping Kam · Post by **Ping Kam** » Tue 30 Nov 2004 17:57

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?

Paul · Post by **Paul** » Thu 02 Dec 2004 07:36

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.

Ping Kam · Post by **Ping Kam** » Thu 02 Dec 2004 16:12

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.