|Re: Lookup Call Parameterization [message #1063632 is a reply to message #1063600]
||Thu, 13 June 2013 10:41
| Jeremie Bresson
Registered: October 2011
Using '%:Ref%' directly in your statement can not work, because the statement processor does'nt do "replace by the string value" (see Top 10 JDBC Best Practices for Java Programmer, item #6: Use Bind variables instead of String concatenation).|
If you want to concatenate an other string to :ref, you need to do it the way your database engine is expecting it.
This should work with Oracle:
MYCOLUMN LIKE '%' || :Ref || '%'
I remember that if you do MySql you will need to use CONCAT... You can search for "SQL String concatenation" in Google and you will find what is suitable for your db engine.
Powered by FUDForum
. Page generated in 0.02314 seconds