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;