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!

Ora-1400 insert null error

893037Oct 7 2011 — edited Oct 7 2011
Hi guys,

I'm having a problem where I'm trying to select the PK value from table A to insert it into my table B.
I'm not getting any problems when I hard code the value into the table A.
Getting this problem after i create sequence and using nextval to create a unique primary key in table A.
Any advises?

Using : sql developer 10g on Ubuntu 11.04
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 4 2011
Added on Oct 7 2011
16 comments
8,252 views