Originally Posted by Old Pedant
If it throws an error, then it's not conformant with ANSI SQL, at all.
ANSI says a DELETE that affects zero records is never an error.
I would be truly surprised if Oracle went against ANSI on something this fundamental.
If you are only looking to see how many records were deleted, most DB interfaces will give you that information.
Thanks, Pedant. I didn't think it would, but I've got a weird error when trying to delete a record. Trying to track down what is causing it, and thought that _maybe_ Oracle was erroring if the record did not exist.
If anyone knows of a website that can offer ColdFusion help that isn't controlled by neurotic, pedantic jerks* (stackoverflow.com), please PM me with a link.
* The neurotic, pedantic jerks are not the owners; just the people who are in control of the "popularity contest".