Monday, December 19, 2005

java.sql.SQLException: ORA-01006: bind variable does not exist

It could be because you have left the String variable in the query as '?' and then setting it by setString(, ) and this leads ot the Exception.

Solution is to remove the single quotes in the Query around question mark
Posted by at

2 comments:

Quick Start said...

Thank you.

2:32 PM
Unknown said...

am trying to excute a query like dis SELECT * FROM bdmstatus WHERE dates BETWEEN 01/02/2014 AND 04/02/2014 but the result will be coming in a single date(first date).
but i want a result in between two dates................

so please help me....

11:18 PM

Post a Comment

Subscribe to: Post Comments (Atom)