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.
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