Avatar

Level 2

Hello all

In my orchestration I have a Call Stored Procedure task that accepts a bunch of XPath expressions as its parameters (obviously)

The problem arises when the values contain apostrophes/single quotes like : ' insertion fails because they cause syntax errors on the DBMS

Is there an effectve way of "escaping" the apostrophes? I'm trying to use XSLT but the truth is I'm not an expert on that

What are the best practices for SQL sanitization using LiveCycle?

Thanks for your help