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,

[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

Original text of this message