Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_utility.get_hash_value

RE: dbms_utility.get_hash_value

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Wed, 20 Oct 2004 17:10:24 +0200
Message-ID: <2CF83791A616BB4DA203FFD13007824A018D0E59@MSXVS02.trivadis.com>


Hi Jose

>Could anybody tell me under which circunstances different inputs to
>dbms_utility.get_hash_value can lead to the same output.

No idea. But it happens quite often... even if the hashsize is quite big = compared to the number of distinct keys.

>The reason is that I work with a 8.1.7.4 database and need to use
>PLSQL tables with the key based on string values.
>
>So, as the table in indexed by binary integer, I convert the strings
>to integers through dbms_utility.get_hash_value.
>
>I am so afraid of duplicating keys for different strings that I always
>writing comparison snippets to verify that the key is not being used
>by a different string.
>
>Is this an exagerated measure?

When I used it to access PL/SQL tables with string values as a key I = added some code as well...

Chris=20

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Oct 20 2004 - 10:05:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US