Thursday 4 January 2007

Avoiding the Table Does not Exist Error when trying to drop it

A quick clever way to avoid Table Does not Exist Error when you have to drop the table in a pl/sql routine. This method saves you searching the data dictionary user_table:

Begin
execute immediate 'Drop table PRODUCT';
Exception
when others then null;
End;

No comments: