0

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

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by lamikayty
0

I don't know what context or within what type of environment you are trying this but I have code which defines variables like this: (See below) Try this and see if it works.

define &1 
define &2
define &3 
define &4 
define &5 
define &6 
define &7 
define &8 
select * from lxRO_4606b095 where lxToLat=&1  and lxToId=&2 and lxType in (&3 ,&4,&5 ,&6 ,&7 ,&8 )

Edited by mike_2000_17: Fixed formatting

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.