Re: Exception in mysql

[mukesh kurkure]

Hi berry,

I have read the link you had given but I have some doubt like

Are there any functions in MySql which support,

1) "SQLCODE AND SQLERRM" are the Oracle functions which provide us the
Default error code numbers and error messages in Exception Handler.

2) " OTHERS” is an Exception in Oracle which will be getting executed
When no others related Exception was declared i.e.
Default Exception which will be getting executed.

3)"PRAGMA_EXCEPTION_INIT” is a PRAGA which tells the compiler to associate an
Exception name with an Oracle Error number. That allows you to refer to any
internal exception by name and write the specific handler for it.


Please let me know whether we can do this in MySQL

Thanks in Advance

Mukesh