DRG-51400
incomplete SEARCH_ON VALUE or SEARCH_ON TEXT_VALUE clause
Cause
An attempt was made to create or alter an XML Search Index with a SEARCH_ON VALUE or SEARCH_ON TEXT_VALUE clause that did not list a data type specification.
Action
Specify the data type specification for the SEARCH_ON VALUE or SEARCH_ON TEXT_VALUE clause as part of the parameters to the CREATE SEARCH INDEX or ALTER INDEX statements. The data type specification must include at least one of NUMBER, BINARY_DOUBLE, TIMESTAMP, or VARCHAR2.