I have a stored procedure which has been working in some other regions. When i bring the same code down to development and just recompile it and try to run it, i get a -450 failure. I have read that this error would be due to the change in length of linkages. I have checked all the linkages and they have the same lengths in the 2 regions. Coudl there be anything else I could check?
Have you not looked at these links from Google? You needs to actually give us the complete description of the error and not just SQLCODE. So see if these links helps you to correct the length of that input parm correct.