Guest User

Untitled

a guest
Sep 18th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. Sequence error in sql. Sequence number not allowed here
  2. INSERT INTO V1144Engine.T_NODES VALUES
  3. (
  4. (SELECT V1144ENGINE.S_PK_NODES.NEXTVAL FROM dual),
  5. 1,
  6. 'Chemistry of Life',
  7. 0,1,
  8. SYSDATE,
  9. NULL,
  10. 'CON.3.1',
  11. NULL
  12. );
  13.  
  14. SELECT V1144ENGINE.S_PK_NODES.NEXTVAL from dual
  15.  
  16. INSERT INTO V1144Engine.T_NODES
  17. VALUES(V1144ENGINE.S_PK_NODES.NEXTVAL,
  18. 1,
  19. 'Chemistry of Life',
  20. 0,
  21. 1,
  22. SYSDATE,
  23. null,
  24. 'CON.3.1',
  25. null);
  26.  
  27. INSERT INTO V1144Engine.T_NODES( <<list of columns>> )
  28. VALUES(V1144ENGINE.S_PK_NODES.NEXTVAL,
  29. 1,
  30. 'Chemistry of Life',
  31. 0,
  32. 1,
  33. SYSDATE,
  34. null,
  35. 'CON.3.1',
  36. null);
Add Comment
Please, Sign In to add comment