What is difference between between SIGNAL and RESIGNAL? Both of them seems to have the same type of syntax., kindly help me out to understand things...

thanks
Sn

The difference is this:
for SIGNAL
1) the SQLSTATE must be stated unless signalling a named condition
2) can be placed anywhere
For RESIGNAL
1) Must be in condition handler
2) SQLSTATE is optional, if omitted will use sqlstate that caused condition handler to execute.

HTH

Andy

Thanks for the info andy.

regards,
Sn