Hi John,

simply write
for select x from y
into z
do suspend;

> 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
>

--
Thomas.Beckmann@...
Martens & Prahl EDV, Wielandstr. 14c, 23558 Lübeck
Telefon 0451-39904-525 • Telefax -520/-559