Hi,
I have a stored procedure and change the length of a parameter from 20 to 890 and the procedure works normally.
However, when I use it in my application, and get to the function: CallRetrievalStoredProcedure and check the value of this parameter, it is a string of 21 chars long. (Still when I check the value of the parameter right before the call to Adapter.Fill
When I do a check in SQL Profiler, the value of the parameter has changed to the same string, but cut off all after the 20 characters.
So somehow the query string cuts off the length to the length of 20 the stored procedure had before. However, I have dropped the old one, added it again with the new length, nothing changed.
When I run
SELECT *
FROM INFORMATION_SCHEMA.PARAMETERS
WHERE SPECIFIC_NAME LIKE '%ACTION%'
I get the stored procedure in the list and it says that the parameter has a length of 890.
Can anyone tell me why the adapter.fill is still using the length of 20 when generating the procedure?!?