Help: Concatenating Records

From: Christine Elssner <celssner_at_aixterm3.urz.uni-heidelberg.de>
Date: 1997/12/01
Message-ID: <65u32l$b9f@sun0.urz.uni-heidelberg.de>#1/1

Hi,

I'm looking for help for the following problem:

I'm trying to write a Procedure to concatenate several records retrieved by a select statement. When trying to run the procedure, I get the following error messages:

ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYSKEY.KANDIDATEN", line 13
ORA-06512: at line 1

And this is the procedure:

CREATE or replace PROCEDURE KANDIDATEN (prof number) as

kandidat varchar2(2000):='';
xxx long;
cursor cur is

        select a.vnam||' '||a.name||' ('||DIENSTE.TEXTN(d.ANTI,100125)||' '||initcap(d.vnam)||' '||initcap(d.name)||') ' x

	from studenten a, pruefungen b, pruefer c, pruefer d
	where prof=b.pruefers and b.dts IS NOT NULL and b.noteps IS NULL 
	and a.matr=b.matr and b.gutachter=d.persnr;

BEGIN
for rec in cur loop

	kandidat:=kandidat||rec.x;
	xxx:=kandidat;

end loop;
--update pruefer set pruefer.kandidaten=kandidat

• where pruefer.persnr=prof;
  --commit;
  END kandidaten; /

Any Ideas?

Greetings,

        Christine Elssner Received on Mon Dec 01 1997 - 00:00:00 CST