0 - 1 of 1 tags for continue handler

I am using a CONTINUE HANDLER as part of my stored procedure to manage Dropping of Indexes.

I do not want the SP to error out becuase an Index doesn't exist as I am just wanting to drop it any way.

The CONTINUE HANDLER does just fine if there is 1 index missing if there are multiple then the handler is no longer managing the process and the SP errors out with a message of 'Index doesn't exist'

DECLARE CONTINUE HANDLER FOR SQLSTATE VALUE '52004'
DDLERROR: BEGIN
INSERT INTO NSBI_TDB.ETL_DEBUG VALUES(CURRENT_TIMESTAMP(0), c_PROC_NM, 'INDEX0 DROP',SQLSTATE);