ORA-2287 sequence not allowed here [message #39159] |
Fri, 21 June 2002 10:23 |
Anthony
Messages: 48 Registered: September 2000
|
Member |
|
|
Hi all,
I want to insert records into a table from three different tables. I am using "insert into ... select.. " The primary key I am trying to populate using a sequence, in one of the other fields, I am summing up some totals I am also using a group by statement.
The message error message I get is that I canīt use a sequence here, is there a reason for this (oracle limitation frīinstance), is there a way around this? or have I made a mistake in coding?
(Please someone tell me Iīve missed a coma somewhere!)
TIA
|
|
|
|
|