ORA-64151: Invalid use of DBMS_XMLINDEX.PROCESS_PENDING.
Cause: DBMS_XMLINDEX.PROCESS_PENDING was called on an index that was not modified using NONBLOCKING ADD_GROUP or ADD_COLUMN.
Action: None
ORA-64151: Invalid use of DBMS_XMLINDEX.PROCESS_PENDING
Error
ORA-64151 is an Oracle error code, which arises when an invalid argument is passed to DBMS_XMLINDEX.PROCESS_PENDING. This procedure is part of the DBMS_XMLDOM package, which is a domain-specific language package that provides developers with a set of APIs to manipulate and query XML documents using Oracle PL/SQL (Procedural Language/Structured Query Language).
Common Cases
One common cause of this error is attempting to use DBMS_XMLINDEX.PROCESS_PENDING on a non-existent table. It is also possible that the table exists but does not have the necessary privileges for the procedure to be executed. Additionally, this error can arise if the table contains multiple XML documents, and DBMS_XMLINDEX.PROCESS_PENDING is being called with invalid parameters.
Resolution
In the case of attempting to use DBMS_XMLINDEX.PROCESS_PENDING on a non-existent table, you should create the table with all the relevant privileges. When the table already exists, but the procedure is being called with invalid parameters, you should check the procedure arguments to ensure they are valid. Additionally, you should grant relevant privileges on the table in order to grant the necessary access to execute the procedure. Finally, if the table contains multiple XML documents, you may need to create separate indexes for each document.