I’m using version 10.1.1.8 on Oracel 10G. When I run a simple sql with a bind
variable, Toad takes at least 10-15seconds to come back and ask for variable
value. But when I put in the variable value directly, the sql runs immediately.
Any ideas why the delay with bind variables?
an example sql could be : select * from clients where client_id = :client_id;
This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.
This has been resolved. I had to delete the Variables.dat file in the \user
files directory. It had grown to 714kb (still not so big) but was causing this
delay.