Comment on page
MSCEWI4067
Invalid parameters in OPENXML table-valued function.
Critical
This EWI is added when there are invalid parameters in the OPENXML, specifically when the XML path cannot be accessed.
To avoid this EWI, please send the explicit node path through the parameters.
SELECT
*
FROM
OPENXML (@idoc, @path, 1) WITH (
CustomerID VARCHAR(10),
ContactName VARCHAR(20)
);
SELECT
*
FROM
-- ** MSC-ERROR - MSCEWI4067 - NODE PATH CANNOT BE ACCESSED **
-- PUBLIC.OPENXML(idoc, variable, 1) WITH (CustomerID VARCHAR(10), ContactName VARCHAR(20)
-- )
;
- No additional user actions are required.