Hello - We’re calling an Oracle stored procedure from a wM StoredProcedure adapter service template. One of the fields we’re passing to the stored procedure contains an ampersand (e.g. “M & Ms Chocolate”). The stored procedure is not able to interpret the & and thus doesn’t return any data (we get an ORA-01403: no data found). We know this because when we run the SQL directly in Oracle, we do get data back.
Has anyone seen this before? We’ve tried sending it as 'M '||CHR(38)||‘M Chocolate’ but that didn’t work either. Any ideas?