So here's an issue I ran across this last week. I have an windows service that connects to an oracle 9i database. It's a pretty simple app really, all it needs to do is select from tables in the database and insert into the tables. 5 of the 6 inserts work just fine. However the last one only inserts the last record in the dataset. The one major difference between this table and the other 5 is it has a field in it that's a reserved word in oracle “UID“. The dataset is strongly typed and I've attemped the insert (adapter.update) using the oracle data provider and the oledb provider for oracle. Both yield the same results. I even went so far as to write an oracle stored proc to handle the insert instead of raw SQL.
FYI, if I change the reserved field name to something other than the reserved name the insert works like a charm. Also, the select statement works just fine retrieving all records from the table. So the problem is only with the insert.
So what say you people? Has anyone come across this before?