Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Stored Procedure Error Handling

forums forums SQLyog Using SQLyog Stored Procedure Error Handling

This topic contains 1 reply, has 0 voices, and was last updated by  Snappit 3 years, 11 months ago.

  • Author
  • #13298


    Hi Guys,


    I’m in the middle creating stored procedure in SQLyog. Could someone help me on error handling? can I use try and cathe in SQLyog? please help me give some sample.


    many thanks

  • #35139



    Try catch is not used in MySQL. 

    Mostly error handling in stored procedure is done by DECLARE … HANDLER please refer-http://dev.mysql.com/doc/refman/5.7/en/declare-handler.html


    You can use this in stored procedure to execute some specific task if error occurred(same as you do in catch) and then exit or continue.


    To  derive the exact nature of the error you can use GET DIAGNOSTICS please refer-http://dev.mysql.com/doc/refman/5.6/en/get-diagnostics.html


    SQLyog doesn’t have any specialized way of doing error handling.

  • #35140


    thanks for your help

You must be logged in to reply to this topic.