Hello, I've got a strange one that can't seem to figure out. I have a grid based on a complex view with an "instead of" trigger on the database. I can issue DML on the view from sql plus no problem no errors occur. When issuing a api_datasource.doCommit statement I keep getting the above oracle error ORA-01422. I can see that my instead of trigger is completing as I've put debug in, my question is does the api_datasource.docommit process do some kinda (perhaps query back rows commited or something) check after comminting the data that could be causing this issue??? |
Doh, figured it out.... View was a child of a parent and I had the wrong field set for the primary key, so it looks like the docommit does perform some check note to self, try to use not so similar field names in the future.... mta_id and mla_id :) |