I have a table to popluate and key ID field is a oracle sequence .
There is a trigger on the table to populate sequence ID.
When i try to populate the tabe using Oracle Enterprise , it is looking for ID field in the table regardless of me not mentioning the field in the columns.
It throws a error
Not writing to column ID, and the field does not accept nulls.
Any idea on how to resolve ?
I am using the same logic in server edition job and i have no issue populating the table.
Please share your thoughts.
Issue with Oracle enterprise
Moderators: chulett, rschirm, roy
Issue with Oracle enterprise
There is nothing good or bad, but thinking makes it so. --William Shakespeare
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 783
- Joined: Mon Jan 16, 2006 10:17 pm
- Location: Sydney, Australia