Re: BINARY_CHECKSUM IN ORACLE

From: Vinay Bhushan <bhushanvinay_at_gmail.com>
Date: 3 May 2006 05:14:06 -0700
Message-ID: <1146658446.381541.114420@y43g2000cwc.googlegroups.com>

Thanks a lot for the effort,

In regard to the question what i asked i think it would have been much clear if i could have mentioned the oracle version and the purpose of doing it also.

Currently i use Oracle version 9 i ,

The reason why its a binary check sum is to hold a logical key to the position, if a accounting data refresh happens and a position doesnot change then we dont calculate or change other data accordingly hence we calculate a checksum for fields like accountid, price, date and other data in it which helps us to identify the position uniquely.

i will try with the follwoing and let you know regarding this "OWA_OPT_LOCK" is there any reason why oracle doesnot provide a binary_checksum function. may be the question is too much to think about all i want is to calculate the binary checsum at EOD.

Regards
Vinay Received on Wed May 03 2006 - 07:14:06 CDT