Running a stored procedure with single quotation marks as the escape character

When you run a stored procedure from the SQL editor that uses an argument that contains two consecutive single quotation marks '', you might get the following error:

To work around this issue, use a parameter marker ? as the argument and in the host variables panel provide the argument in the Value field.