Thanks for your reply.Because when I am running this command on sql server its giving me proper output,but while running it from perl script its giving error.
That doesn't explain why you're not checking for errors, why you assume each and every call succeeds.
Comment on Re^3: Running stored procedure through perl script