Prepared statment executeQuery() error.
posted 16 years ago
-
-
Number of slices to send:Optional 'thank-you' note:
-
-
Hi,
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 ?
Could some one help me out ?
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 ?
Could some one help me out ?
Pass on the knowledge!!
posted 16 years ago 
-
- Number of slices to send:Optional 'thank-you' note:
-
-
I've added code tags to make it more readable.
I only see 3 "?" bind variables in the query. How does the fourth one fit in?
I only see 3 "?" bind variables in the query. How does the fourth one fit in?
[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
Karthik Krishna
Greenhorn
Posts: 11
posted 16 years ago
-
- Number of slices to send:Optional 'thank-you' note:
-
-
Sorry Jeanne
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.
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!!
| Why fit in when you were born to stand out? - Seuss. Tiny ad: Paul Wheaton's 16th Kickstarter: Gardening playing cards for gardeners and homesteaders https://coderanch.com/t/889615/Paul-Wheaton-Kickstarter-Gardening-playing |