CREATE OR REPLACE PROCEDURE dropexist(tablename varchar2)
IS
BEGIN
EXECUTE IMMEDIATE 'DROP TABLE ' || tablename;
EXCEPTION
WHEN OTHERS THEN
IF SQLCODE != -942 THEN
RAISE;
END IF;
END;
Volání standardně v PL: begin dropexist('tmp_test_dummy'); end;