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);