drop table t2 purge;
drop table t3 purge;
create table t1(n1 number, n2 number);
create table t2(n1 number, n2 number);
create table t3(n1 number, n2 number);
create sequence s1;
Problem:
INSERT ALL
INTO t1(n1, n2) values(n1_seq, nn)
INTO t2(n1, n2) values(n1_seq, nn)
select s1.nextval n1_seq, rownum*10 nn from dual connect by level <= 2;
Error report -
SQL Error: ORA-02287: sequence number not allowed here
02287. 00000 - "sequence number not allowed here"
*Cause: The specified sequence number (CURRVAL or NEXTVAL) is inappropriate
here in the statement.
*Action: Remove the sequence number.
Fix:
INSERT ALL
INTO t1(n1, n2) values(s1.nextval, nn)
INTO t2(n1, n2) values(s1.currval, nn)
INTO t3(n1, n2) values(s1.currval, nn)
select rownum*10 nn from dual connect by level <= 2;
select * from t1;
select * from t2;
select * from t3;