DSXchange

Hi,

We have an Oracle stage with a custom insert SQL. To fulfill some requirements, we are modifying the insert to include a function so that my insert will look something like :
As can be seen, one of the functions takes 2 parameters and I have no clue how to escape the comma between both these parameters.

Help appreciated.

Are you sure you need to escape it at all? Are you getting a syntax or runtime error that you can share? If for some reason that approach isn't manageable, you could use the function in a lookup / select before the insert so that you just have a 'normal' value to insert in the target. Or perhaps even in the source SQL itself if applicable.

Thanks Craig.
The error I was getting was because of incorrect bind variables and not because of the comma. Got through it. Thank you