DRG-11730: relation does not exist

Just a quick note today about the following error:

ORA-20000: Oracle Text error: DRG-11730: relation does not exist

As explained in my previous posting, the lack of the qualifier associated to either phrase in the relation may cause the error above.

Yet it's interesting to note that if you receive this error, it means implicitly that the term(s) specified in the CTX_THES.DROP_RELATION call are actually existing, what is not existing is the relation between them because if either of the term(s) wouldn't exist in the specified thesaurus, you'd get DRG-11704.

The reason why i wrote term(s), with an optional plural is due to the fact that you can omit the related phrase in CTX_THES.DROP_RELATION, which means that you can drop all narrower or broader terms related to the primary phrase with a single call.