Sequence error in sql. Sequence number not allowed here Sequence error in sql. Sequence number not allowed here sql sql

Sequence error in sql. Sequence number not allowed here


There is no need to have the inner SELECT. Simply

INSERT INTO V1144Engine.T_NODES   VALUES(V1144ENGINE.S_PK_NODES.NEXTVAL,         1,         'Chemistry of Life',         0,         1,         SYSDATE,         null,         'CON.3.1',         null);

In general, though, you want to list the columns that you are providing values for in your INSERT statement. That not only documents the columns so that a future developer doesn't have to look up the order of columns in a table, it protects you if new columns are added to the table in the future.

INSERT INTO V1144Engine.T_NODES( <<list of columns>> )   VALUES(V1144ENGINE.S_PK_NODES.NEXTVAL,         1,         'Chemistry of Life',         0,         1,         SYSDATE,         null,         'CON.3.1',         null);