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