From oracle-l-bounce@freelists.org Mon Jul 11 13:39:54 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6BIdsKa021495 for ; Mon, 11 Jul 2005 13:39:54 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j6BIdoIP021480 for ; Mon, 11 Jul 2005 13:39:50 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 706441CBE16; Mon, 11 Jul 2005 13:39:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 24908-05; Mon, 11 Jul 2005 13:39:47 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id EDE861CBE11; Mon, 11 Jul 2005 13:39:46 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=IF8PyGb1k26B4atbPXoIMAJzY2Et6lN9MkW4V5Gu9snKe8Gs0DZ1QZUTcFH1hYhIipkEuA4PXmOmRphGJqaAiRLdTn/g4aKvVUEIEvWmgClnVnHK36HFomtiO4lF4BEMaP3yY/15Tf2otm3TUboLSDdJPG+uQh8dTN0aNb9TB/4= ; Message-ID: <20050711183759.68266.qmail@web50803.mail.yahoo.com> Date: Mon, 11 Jul 2005 11:37:58 -0700 (PDT) From: Tapan Trivedi Subject: {Dangerous Content?} Obfuscation Toolkit Question.... To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: multipart/mixed; boundary="0-886685481-1121107078=:67884" X-archive-position: 22299 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: taptriv@yahoo.com Precedence: normal Reply-To: taptriv@yahoo.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be infected X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-1.8 required=5.0 tests=AWL,BAYES_00, FORGED_YAHOO_RCVD autolearn=no version=2.63 --0-886685481-1121107078=:67884 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Warning: This message has had one or more attachments removed Warning: (msg-21564-1312.html). Warning: Please read the "mailscan-Attachment-Warning.txt" attachment(s) for more information. I am using DBMS_OBFUSCATION_TOOLKIT to encrypt certain sensitive columns. I also have a need to compare those columns and hence the need to store the same values in a hash value so that it can be compared when sent to clients with the hash value key. The encrypted values by the OBFUSCATION_TOOLKIT cannot be compared from what I know. How do generate hash values for the data already stored in the database and use the same for comparing etc ? Has anyone worked on this ? ANy function written that I can use ? I need this first for a demo(urgent) and then for the actual implementation (breather of two weeks). Any help , pointers will be appreciated. Sincerely, Tapan Trivedi Tapan Trivedi Senior Oracle DBA 916 613 1921 test'; "> test'; "> --0-886685481-1121107078=:67884 Content-Type: text/plain; charset="us-ascii"; name="mailscan-Attachment-Warning.txt" Content-Disposition: attachment; filename="mailscan-Attachment-Warning.txt" Content-Transfer-Encoding: quoted-printable This is a message from the MailScanner E-Mail Virus Protection Service ---------------------------------------------------------------------- The original e-mail message contained potentially dangerous content, which has been removed for your safety. The content is dangerous as it is often used to spread viruses or to gain personal or confidential information from you, such as passwords or credit card numbers. If you wish to receive a copy of the original email, please e-mail helpdesk and include the whole of this message in your request. Alternatively, you can call them, with the contents of this message to hand when you call. At Mon Jul 11 13:39:54 2005 the content filters said: MailScanner: Found dangerous IFrame tag in HTML message Note to Help Desk: Look on the MailScanner in /home/virtual/site1/fst/var/s= pool/mail.quarantine/20050711 (message j6BIdoIP021480). --=20 Postmaster MailScanner thanks transtec Computers for their support --0-886685481-1121107078=:67884-- -- http://www.freelists.org/webpage/oracle-l