grl Posted August 18, 2014 Share Posted August 18, 2014 If I try to include a parameter in my sql statement select * from table where (...) group by (...) fetch first $P{param} rows onlyI get the error "mismatched input '$P{param}' expecting RULE_INT"$P{param} should evaluate to an integer, as set by the user.How could this error be avoided ? Thanks ! Link to comment Share on other sites More sharing options...
sfriedman Posted August 19, 2014 Share Posted August 19, 2014 Use $P!{param}. The exclam makes the value an unquoted string. Link to comment Share on other sites More sharing options...
grl Posted August 21, 2014 Author Share Posted August 21, 2014 Thank you so much for your answer, but I am still getting the same error .... Link to comment Share on other sites More sharing options...
grl Posted August 21, 2014 Author Share Posted August 21, 2014 anyone has any other suggestion on this issue ? Thanks ! Link to comment Share on other sites More sharing options...
chboutteau Posted May 18, 2016 Share Posted May 18, 2016 Hello,Did you find how to get it work ? I have the exact same issue.ThanksCharlotte Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now