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