could you please explain me, why are large (complicated) queries so much faster when using substitution variables instead of other types (integer, string, date). If I run query in pl/sql developer the query is very fast (2 secs), when I run it within TOracleDataSet, the execution is so much slower (60 secs)...Of course, if I use substitution variables, then I have to be careful about right format of variable...

Thank you for the answer!
Could you give an example of the sql and the contents of the variables?

© Allround Automations forums