1

Topic: utl_match.jaro_winkler clob> 4000

Respected, nobody met a problem of comparing CLOB in length> 4000 through tl_match.jaro_winkler? At me the error that too long is produced a line. Whether there are alternatives which allow to compare big CLOB and to range them on a similarity level?

2

Re: utl_match.jaro_winkler clob> 4000

Dima Ry;
With the registration of that utl_match.jaro_winkler works with varchar2, it is expected by a call in sql.
Is better describe, for the decision of what task you need to compare through jaro_winkler lines of more than 4000 characters.

3

Re: utl_match.jaro_winkler clob> 4000

env wrote:

describe Is better, for the decision of what task you need to compare through jaro_winkler lines of more than 4000 characters.

To compare texts. An one-time problem.
At us scripts are stored in clob and some programmers produced ctrl-c ctrl-v similar scripts, but incoincident, it would be desirable them to analyze.

4

Re: utl_match.jaro_winkler clob> 4000

Dima Ry;
I would preempt these CLOB in the form of files and would set search of doubles / the similar. Utilities - the sea.