stored procedure error handler for volatile tables

Database

stored procedure error handler for volatile tables

Hi,

I am working with volatile tables in stored procedure.

I need to handle errors for drop table X:

a) when table being dropped already exists (from prior run of stored procedure)

b) when table being dropped doesn't exist yet (first run of stored procedure)

I want to drop volatile tables created by sotred procedure, but I cannot find anywhere SQLSTATE values to handle those two errors.

Anyone struggled with this before. This is for voaltile tables....

Regards,

Piotr