Exception Handling in Stored Proc's
Hi,
Can someone explain how ON EXCEPTION works in stored proc's. If you have
sample code, it would be much appreciated.
I'm trying to trap table already exist - error number -310. If the table
exist
then I want to drop it.
Here's the code I've tried (syntax is off the top of my head):
BEGIN
ON EXCEPTION IN (-310)
DROP TABLE tempMan
END EXCEPTION WITH RESUME
BEGIN
SELECT x, y, z
INTO TEMP dah
WITH NO LOG
END
END
END
Thanks