This week's book giveaway is in the OCAJP 8 forum. We're giving away four copies of OCA Java SE 8 Programmer I Study Guide and have Edward Finegan & Robert Liguori on-line! See this thread for details.
Can I use a prepared statement to execute "select" queries? I get an error when I try to use it using JDBC..Here is the following error SQL Exception from class SqlArrayTest executeStashQuery method java.sql.SQLException: ORA-01008: not all variables bound Here is my query "SELECT TO_CHAR(BUSINESSDAY,'YYYYMMDD'), TO_CHAR(RCV_DATE,'YYYYMMDD') FROM RCV where STOREID=?" Pls clarify at the earliest
Assuming that "STOREID" is an integer value, you need to make sure you call ".setInt(1, xxx);" on the prepared statement, where "xxx" is the int value you are searching on. This has to be done before you call "executeQuery()" on the prepared statement. When you set up a prepared statement, the question marks (?) represent parameters that you will specify at execution time. For every parameter [?] in the query, you must call the appropriate setXXX() method. The error message you're getting seems to indicate that your parameter wasn't bound to a value, meaning you hadn't called "setInt()" before executing the query. If this isn't your problem, please show us your code fragment. [ February 18, 2004: Message edited by: Wayne L Johnson ]