Hi,
I am trying to cluster a text field using text mining. The table structure is simple: an id column and one CLOB text field.
When I try to index the text field, it works fine. But as I try to cluster using the following command:
exec ctx_cls.clustering('<index_name>','id','restab','clusters','my_cluster');
It gives me an error "ORA-01480: trailing null missing from STR bind value"
I have checked, all the records do have trailing nulls.
select count(*) from <table>where instr(<text_field>,(chr(0)),1,1) > 1;
The complete stacktrace is pasted below:
[Error] Execution (46: 1): ORA-20000: Oracle Text error:
DRG-50857: oracle error in drctrkb
ORA-01480: trailing null missing from STR bind value
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_CLS", line 415
ORA-06512: at line 1
Please help!!! and quick!!!