我设法找到了一个非常简单的解决方案,只是添加了[text()=“ Form3”] /…/“来声明Xpath,如下所示
SELECT
ExtractValue(Value(p),'/Customer/Loyalty/Client/Identifications/Identification/*[local-name()="Form"][text()="Form3"]/text()') as form,
ExtractValue(Value(p),'/Customer/Loyalty/Client/Identifications/Identification/Form[text()="Form3"]/.../*[local-name()="value"]/text()') as value
还提取值,然后将它们直接发送到过程的OUT参数中:
P_FORM := r.form;
P_LOYALTY_VALUE := r.value;