My Oracle Support Banner

DRG-52210: error while registering value for attribute: NUMJOIN ORA-01400: cannot insert NULL (Doc ID 2638358.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, XML Database
When creating Oracle Text preference fails with:


begin
  ctx_ddl.create_preference('"<PREF_NAME>"','BASIC_LEXER');
  ctx_ddl.set_attribute('"<PREF_NAME>"','PUNCTUATIONS','.,?!¿¡');
  ctx_ddl.set_attribute('"<PREF_NAME>"','PRINTJOINS','/');
  ctx_ddl.set_attribute('"<PREF_NAME>"','SKIPJOINS','.-~');
  ctx_ddl.set_attribute('"<PREF_NAME>"','NUMJOIN','');
  ctx_ddl.set_attribute('"<PREF_NAME>"','CONTINUATION','-');
  ctx_ddl.set_attribute('"<PREF_NAME>"','BASE_LETTER','YES');
  ctx_ddl.set_attribute('"<PREF_NAME>"','MIXED_CASE','NO');
  ctx_ddl.set_attribute('"<PREF_NAME>"','INDEX_TEXT','YES');
  ctx_ddl.set_attribute('"<PREF_NAME>"','INDEX_THEMES','NO');
  ctx_ddl.set_attribute('"<PREF_NAME>"','BASE_LETTER_TYPE','SPECIFIC');
end;
/


begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10705: invalid value NULL for attribute NUMJOIN
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVLSB", line 78
ORA-06512: at "CTXSYS.CTX_DDL", line 75
ORA-06512: at line 6

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.