SQL & PL/SQL

Hi Guys,

I need your help. I am having a big table with millions of records, I have developed an Fuzzy Search Utility to search with in the table for the Strings(Names) inputted by the user for which i have used the UTL_MATCH.Jaro_Winkler_Similarity function as i felt this function retrieves best matches compared to UTL_MATCH.EDIT_DISTANCE_SIMILARITY based upon the alogorithms and the functionality desired for my application, but the problem is that sometimes when i use the JARO_WINKLER_SIMILARITY function , I am getting error message " NO MORE DATA TO READ FROM THE SOCKET " and its working fine with EDIT_DISTANCE_SIMILARITY function. I 'd really welcome your opinions and experiences of selecting between those functions.

Regards,
Venu Kadiyala

kadiyalavenu@hotmail.com