Hello,
           in postgres function (id bigint ),the following code not return
any value with artNums ,But when i do  select statement ony it's output the
values with out include cursor

 i.e,cursor problem ..?

please let me know what should i do to getvalues from cursor, but i dont
where i missing

 function (id bigint )

DECLARE
      PartNums   varchar (10000);
 artNums CURSOR for
      SELECT p.PART_NUM part_num
        FROM lineitem sol, part p
       WHERE sol.ORDER_ID = id AND p.PART_ID = sol.PART_ID;

   BEGIN
      FOR cPart IN  artNums LOOP
   BEGIN
        PartNums := PartNums || cPart.part_num || ', ';
END;

Reply via email to