CREATE OR REPLACE procedure hola_mundo (textarea varchar2) AS
cursor c1 is select aviso from avisos_emt where destinatario like '%'||textarea||'%';
BEGIN
for reg in c1 loop
htp.print(reg.aviso);
end loop;
END;
/