I'm trying to figure out how to get a procedure to return more than one row. I
know that this procedure does not work because it is supposed to return
multiple rows and this one can't. So - how is it to be re-written som it
works?

CREATE PROCEDURE SEL_PROC_V_PRESENTASJON (
IN_KAT VARCHAR (100))
RETURNS (
V_ID_KATEGORI INTEGER,
V_KATEGORI VARCHAR (100),
V_ID_LEVERANDOR INTEGER,
V_LEVERANDOR VARCHAR (100),
V_URL VARCHAR (254),
V_KALKURL VARCHAR (254),
KAT_CNT INTEGER)
AS
BEGIN
select ID_KATEGORI, KATEGORI, ID_LEVERANDOR,
LEVERANDOR, URL, KALKURL
from view_presentasjon
where kategori like :in_kat
order by kategori into
:V_ID_KATEGORI, :V_KATEGORI, :V_ID_LEVERANDOR,
:V_LEVERANDOR, :V_URL,:V_KALKURL;
suspend;
END

--
Best regards


John H. Jaabæk
tlf. +47 915 24 599