Most of the time, I've seen the oracle column ID value have a default value of the next sequence number so all you would have to do is not include that column in the insert statement. If the column has no default value and you can't add one, I would next look at creating a temp oracle table which would allow you to execute the insert via pass through.
... View more