Skip to Main Content
Forums

Oracle Database Discussions

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.nextval returns NULL

729069Nov 17 2009 — edited Nov 18 2009
Hello,

when does this .nextval will return a null value?

I am using this sql statement:
INSERT INTO wsdaten (LFDNR, DATEN) VALUES (wsdaten_sq.NEXTVAL , :DATEN)

This statement sometime fails, because of a null value for wsdaten_sq.NEXTVAL , lfdnr is a primary, not nullable

I am using a 10.2.0.3.0 database on solaris 10.
The maxvalue of wsdaten_sq is large enough.

Can anybody help me?

Regards,
Thomas
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 16 2009
Added on Nov 17 2009
#general-database-discussions
12 comments
4,190 views