consult database table and repeat a determined process for each value obtained from a specific field

Summary

consult database table and repeat a determined process for each value obtained from a specific field of the table.

Content

Hi everyone,

I am working on a requirement in which I must obtain a record of a table and for each record to generate a file, I am currently working only with the name field I try to recover all the names of the table and for each one to generate a .txt file where print that name but I get an error:

"XPath query string returns multiple nodes. The assign activity part and query $messagecontext_30.parameters/../nsmpr2:HomeDirectoryCollection/nsmpr2:HomeDirectory/nsmpr2:fname are returning multiple nodes. The assign activity part and query named in the error message returned multiple nodes. It should return single node. According to BPEL4WS specification 1.1 section 14.3, the assign activity part and query named in the error message should not return multiple nodes. Verify the part and xpath query named in the error message at line number 932 in the BPEL source.