I have not had any success with stored procedures that include the XMLTABLE() function. They get marked as errors in the Visual Studio environment, either with “There is no possible parse follow up …” or with “Value cannot be null. Parameter name: key ”. The stored procedures compile and work fine in PL/SQL.
Maybe XMLTABLE() is just not supported? Does anyone have an example that works?