存程中，怎用一返回的集啊？
我有一
CURSOR cur_sap IS
SELECT A.MATNR as MATNR ,A.WERKS as WERKS, A.LGORT as LGORT
FROM MARD A,MARA B
WHERE A.MANDT = p_mandt
AND A.WERKS IN （.....）
AND ....

其中括中要入的件是下面段SQL返回的KXK02
SELECT KXK02 FROM KXK_FILE
WHERE KXK01= '... '
AND KXKACTI= '... '

大家忙看看，我怎用啊?

[解决办法]
理解错楼主的意思了