error select

tema enviado por lala en ORACLE
tema iniciado el 16/02/2010
Hola a todos: Tengo esta consulta, y no se porque sale error. CREATE OR REPLACE PROCEDURE GET_PACIENTE2 (ESTADO IN varchar2) IS BEGIN IF UPPER(TRIM(ESTADO)) = '1 ESPERA CTRL. SV' THEN SELECT v.id_visit_hosp as dau, p.prename || ' ' || p.name as nombre, p.ssn as rut, trunc((sysdate-p.birth)/365) as edad, v.adm_reason as diagnostico, '' AS ESPECIALIDAD, TO_CHAR(e.event_day,'dd/mm/yyyy hh24:mi') as hora, trunc((SELECT sysdate - e.event_day FROM DUAL)*24*60) as tiempo from event e, visit v, patient p where p.current_event = e.id_event and e.id_visit = v.id_visit and p.id_patient = v.id_patient and p.current_location = 352 and (select count(ev.id_visit) from evolution ev where ev.id_visit = v.id_visit and ev.cancellation = 'N' and ev.TYPE='SV') = 0 order by e.event_day; END IF; END GET_PACIENTE2; el error que me da es: Error(12,6): PLS-00428: se espera una cláusula INTO en esta sentencia SELECT HELP S.O.S