Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem using sequence.nextval in java prepared statement

408112Jun 27 2011 — edited Jul 2 2011

Hi Guy,

Has anyone tried to put sequence.next in java prepared statement? i have some issues issues using it.

ex. below

private static final String SQL_insertEQFCYPRICE = "INSERT INTO TABLE ("
+ " col1, col2, col3, "
+ " VALUES (seq1.nextval,?,?,? )";

regards,
John

This post has been answered by ChrisJenkins-Oracle on Jun 29 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 30 2011

Added on Jun 27 2011

#database-key-features, #timesten-in-memory-database

6 comments

9,300 views