Post reply

how to get error description in stored procedure

  • November 16, 2005 at 5:15 am

    #102932

    Hi,

    Anyone know that, how to get error description in stored procedure. I am getting the error number by @@ERROR. But i need error description.

    I tryed with sysmessages table. But there are many place holders. I need the exact error message like, how the query analyser giving. if any one know abt this please help me.

    Saravanan.

    Kindest Regards,

    Saravanan V
    geocities.com

  • November 16, 2005 at 5:50 am

    #604160

    There is only one place where you can get the complete errormessages, and that's at the other end of the connection calling the procedure. (eg the client)

    You cannot trap complete errormessages within the procedure in many cases - for some types of errors there's simply no way to do that.

    /Kenneth

  • November 16, 2005 at 6:31 am

    #604181

    hmm - I wonder if Saravanan and Gogula are working on the same project..

    error description







    **ASCII stupid question, get a stupid ANSI !!!**

  • November 16, 2005 at 8:22 am

    #604215

    Maybe. I noticed the similarity as well

    /Kenneth

  • November 16, 2005 at 10:29 pm

    #604347

    Thanks friends, We r not in the same project. I don't know that, who is Gogula.

    I try this in some other way.

    Saravanan.

    Kindest Regards,

    Saravanan V
    geocities.com

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply