Posted on 2003-02-23
I try to make a loop with a cursor to obtain all occurences answering my select... but doesn't work. I get only occurence even when many should appear.
I start in programming with oracle , does anyine could help me ?
CREATE or REPLACE FUNCTION Affich_View1 (idparc PARCELLE.PARCELLE_Id_Parcelle%type)
RETURN varchar AS
CURSOR CURS_Vue1 IS
select distinct essence.essence_nom_latin
from essence, composition, observation
where essence.essence_id_essence = composition.composition_id_essence
and composition.composition_id_observation = observation.observation_id_observation
and observation.observation_id_parcelle = idparc;
FOR tuple IN CURS_Vue1 LOOP