Skip to Main Content
Forums

SQL & PL/SQL

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!

Sequence Last Number doesn't match with currval

749382Jan 24 2011 — edited Jan 24 2011
Hi,
I have a sequence and i am using that in a procedure to insert records.Often the procedure throws error like primary key violated.

When i checked the last number used by the sequence it gave me as 27331 and the currval of the sequence as 27312.

Please advice us to rectify this.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 21 2011
Added on Jan 24 2011
6 comments
15,640 views