Skip to Main Content

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to set Sequence current value?

659873Sep 24 2008 — edited Sep 26 2008
Hi,

I would like to force the MySEQ sequence to a precise value, so that the next time, when MySEC.nextval is called, it will be 165. The increment, cache options, etc. remain unchanged. So if the increment was 1, then afterward, this sequence will deliver 166, 167, etc.

Thanks in advance for any help.
This post has been answered by SamB on Sep 25 2008
Jump to Answer

Comments

unknown-7404
>
Do you know what it means?
>
It could mean you don't have the orai18n-collation.jar in your classpath.

Either add the directory where the jar is to the classpath or put the jar in the same directory as the xmlparserv2.jar
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Oct 24 2008
Added on Sep 24 2008
8 comments
34,497 views