char parameter to cursor
From: Bernard Willemot <Bernard.Willemot_at_solluflex.net>
Date: Tue, 17 Aug 1999 20:14:19 +0200
Message-ID: <7pc8j2$fhk$1_at_news3.Belgium.EU.net>
Hi,
Date: Tue, 17 Aug 1999 20:14:19 +0200
Message-ID: <7pc8j2$fhk$1_at_news3.Belgium.EU.net>
Hi,
[Quoted] Have a small problem here passing a special variable of type char to cursor...
declare
thegroup char(10);
cursor c1(what char) is select id from products where id in (what);
begin
thegroup := '5,8,10';
for a in c1(thegroup) loop
insert into requests (prodid) values a.id;
end loop;
end;
/
I supose this is not a realy difficult one, but I cannot find it...
Can anyone help me ?
Thanx, BW. Received on Tue Aug 17 1999 - 20:14:19 CEST