Billing Statement

I’m trying to fix a software issue for a client. The client is using our software against an Oracle database. They are attempting to update records in a table via our software interface. The software generates a SQL UPDATE statement appropriately using a unique key field. The record being targeted is appropriately updated.

HOWEVER, another, totally unrelated record, is being deleted. Even if the user has no delete permissions on the table. The record being lost is the last one that would be returned if you sorted the table based on a different (multi-field) key (which isn’t being used in this procedure).

Any thoughts?

Check FOR UPDATE trigger on this table.

Posted update statement |