This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
I'm trying to insert a row into a table(Oracle) from a java program, using a sequence(seq.nextval) as the primary key.I'm using a prepared statement for this query: INSERT INTO TEST VALUES(ERROR_SEQ.nextval,?,?)
I'm getting the following exception:
ORA-01006: bind variable does not exist
Stack Tracejava.sql.SQLException: ORA-01006: bind variable does not exist