CREATE OR REPLACE PROCEDURE usuarios_avisos_emt_checkbox (destinatario VARCHAR2) AS controlexis number; usuarioinfo varchar2(250); nombrew varchar2(250); cont NUMBER; temp NUMBER; total NUMBER; CONTADOR NUMBER; CURSOR c1 IS SELECT user_name FROM WWSEC_PERSON$ WHERE user_name NOT IN ('PORTAL','PORTAL_ADMIN','PUBLIC','ORCLADMIN'); BEGIN SELECT COUNT(*) INTO total FROM WWSEC_PERSON$ WHERE user_name NOT IN ('PORTAL','PORTAL_ADMIN','PUBLIC','ORCLADMIN'); cont:=1; CONTADOR:=1; htp.print('