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!

Insert Select sequence.nextval Problme

644850Jan 16 2009 — edited Jan 16 2009
Hi,

I am trying to insert records in the table using query similar to

insert into table1 (id, col1, col2)
select
sequence.nextval
t1. col1, t1.col2
from table t1;

I am getting following error

ORA-02287: sequence number not allowed here

Will you please let me know how to resolve this?

Regards
~Pravin
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 13 2009
Added on Jan 16 2009
6 comments
26,456 views