I have the following query in a class, and when this class hits the line ps.executeQuery() I get an exception which says " ORA-01006: bind variable does not exist "
I have been trying to work towards different solutions but i do not understand why the ps.executeQuery fails ? does it have anything to do with the nested queries ? Can I have an inline query and the " ps.setString(1, monthYear);ps.setString(2, monthYear);ps.setString(3, monthYear); " can still substitute the values in the inside query ?
I am just mimicking a situation which I am encountering and for a few reasons I cannot copy paste the code in here so I am just replicating the issue in here.
You could just comment out the following from line 77 through 80.
# if (!fId.equals("91"))
# ps.setString(4, fId);
And another tiny correction line 38 is missing a bracket.
Pass on the knowledge!!
What do you have to say for yourself? Hmmm? Anything? And you call yourself a tiny ad.
Devious Experiments for a Truly Passive Greenhouse!