How to pass values with quotes (') to stored procedure in PX policy

Products

• CA Identity Manager

Issue/Introduction

I have an issue with passing values to a store procedure used in my PX policy.

Because all the values to the procedure are passed between quotes (') the value which contains the same quote causes an error. How can this be solved?

 

Environment

Release :

Resolution

You can use double quotes to escape, so description = 'a''' is really a'

Additional Information

This is in its core just SQL so the same escape characters should be used.