Stati per Select aneinandergereiht

[smudo]

So, ich habs jetzt:

SQL-Code:

CREATE PROCEDURE GETSTATILISTE (
    PNR CHAR(15) CHARACTER SET ISO8859_1)
RETURNS (
    STATILISTE VARCHAR(999) CHARACTER SET ISO8859_1)
AS
DECLARE VARIABLE STATUS VARCHAR(10) CHARACTER SET ISO8859_1;
begin
  statiliste='';
  for select details.status
  from details d
  where d.PNr=:PNr
  into :status
  as cursor StatCursor do
  begin
    if (statiliste='') then
      statiliste=:statiliste || :status;
    else
      statiliste=:statiliste || ', ' || :status;
  end
  suspend;
end^