Hello, I'm getting from an application log the following query:
select * from lxRO_4606b095 where lxToLat=:va and lxToId=:vb and lxType in (:vc,:vd,:ve,:vf,:vg,:vh) :va=1174843541 :vb=1959561595 :vc=1183424550 :vd=1183482004 :ve=1182541895 :vf=1182543699 :vg=1182550204 :vh=1182581348
the problem is that this does not work in Oracle, there seems to be a problem with variable substitution.
Is there a way to perform this substitution without much copy/paste work?? is there some option within oracle that would make it understand the query as it is??
obviously this is a query I'd repeat many time with different variable values, from different tables and using a different number of parameters, so I'd really appreciate if there was a way to do this.
Thanks in advance