Forum Stats

  • 3,872,877 Users
  • 2,266,487 Discussions


Text Clustering giving error ORA-01480: trailing null missing from STR bind value

1062666 Member Posts: 1
edited Jan 2, 2014 6:19AM in Text


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!!!

This discussion has been closed.