Search Result

Hi!

I'm having problems with my update below. I know there's a where -clause missing, but I just can't figure out how it should be done properly. I'm stuck with that ORA-01427.

Thanks for advice! OV.

UPDATE apuarea pa SET pa.subarea =
(SELECT pu.subarea FROM prounit pu, popperson pp, popresidence pr
WHERE substr(pr.build inglabel,1, 14) = pu.unitlabel
AND pr.enddate IS NULL
...

HI!
I MADE A STORED PROCEDURE BUT WHEN I CALL IT ONLY RETURN THE FIRST RECORD AS A MESSAGE, AND DOESNT RETURN ALL THE RECORDS THAT I QUERY.
THIS IS THE CODE:
CREATE PROCEDURE SCHEMA.PROCED21 ( OUT CVE_PROGRAMA INTEGER, OUT NOMBRE_CARRERA VARCHAR(120) )

RESULT SETS 1

LANGUAGE SQL

NOT DETERMINISTIC

READS SQL DATA

P1: BEGIN

DECLARE ANIOI...