You guys are way too good!!
Using bind variables, the query is slow on sqlplus also!!
Unfortunately that also means I have more work to do :(
Need to fix it now. Thanks a bunch!