The problem that I have with this method is that it produces the following error message. Does this mean that I have to change the SPROC to only receive strings or can I make changes at the Perl level?
Syntax error converting the nvarchar value 'x' to a column of data typ
+e int.
Update: The placeholders show as follows:
EXEC sprocname ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
+, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
There was a string like the following: 'ICTABYXIDNUBXdMOCqgwbQRVJNZsfgVqOFrH' which does contain a X