I have a trigger which fires before an insert, for every row.
I check for a certain range of values in a certain column.
If the data is outside this range, I wish to cancel the insert FOR THAT ROW ONLY.
Can this be done and if so, how?
I've tried raise_application_error, but this aborts the entire insert - every row.
Thanks for any help