Calling stored procedure with ampersand in data

, ,
1

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?

Thanks,
Rajesh

2

Scratch that. The issue was with our Oracle developer :slight_smile:

Apparently TOAD requires CHR(38) but not when you call a stored procedure hosted on the database.