RE: Flat file generation integrity ideas...

[Grabowy, Chris]

Title: Message

Tim, I can always count on you for a slick answer.  Thanks.  I will have to check into that. -----Original Message----- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 6:24 PM To: Multiple recipients of list ORACLE-L Subject: Re: Flat file generation integrity ideas... DBMS_OBFUSCATION_TOOLKIT has an (undocumented) function called MD5 which uses that protocol (MD5) to calculate checksums.  Look at $OH/rdbms/admin/dbmsobtk.sql... ----- Original Message ----- From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 12:46 PM Subject: RE: Flat file generation integrity ideas... you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check. Raj ______________________________________________________ Rajendra Jamadagni              MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!