Deleting tables via a SP

I want to use a stored procedure to delete a lot ov tables one table at a time.

In VB I wrote a component that returns a recordset containing the tables. I want to loop that rs, get tablenames (do some checks) and then call a sp to drop/delete the tables.

CREATE PROCEDURE spDelTempTables ( TableName IN varchar2 ) AS
  BEGIN
    DROP TABLE + TableName;
  END; Any help to get out there ??

--
Regards
Robert Vabo
Application developer
Gecko Informasjonssystemer AS
www.gecko.no
robert.vabo_at_gecko.no