CREATE OR REPLACE procedure empleadospruebas
 is
 temp varchar(100);
 begin
 temp:='fran number(3)';
 execute immediate 'drop table pruebafranemt';
   execute immediate 'create table pruebafranemt as select * from avisos_emt';
  end;
/