Is there any equivalent function to MS SQL Servers BINARY_CHECKSUM function? I have tried using the OWA_OPT_LOCK packages CHECKSUM function, but this returns the same result in the following two cases:


in both cases the function returns 37853 - so this tells me that this is not a good way to perform optimistic locking, as it would appear that nothing has changed, when there is quite obviously a difference.

Also I am finding that when calculating the checksum of a number of fields over a large-ish volume of records (100,000s), performance is a big issue (by a large factor slower than MS SQL Servers BINARY_CHECKSUM function - 30 minutes vs 30 seconds!).

Are there any alternative checksum functions available?

Ta in advance.