Thanks

That explains it!

Thanks Sriram

That solved the problem but I ended up needing to change some applications logic to support the parameter.

Really anoying thing is the original code exec @PinNo=GenerateSecurityNo, is the documented method with SQL...