Hi David,
I should have perhaps made clear this was a saved function, so myunderstanding is ROLLBACK can't be used as its implicit.