存儲過程中,怎樣調用一個返回的數據集啊?
我有一個遊標
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= '... '
請大家幫忙看看,我應該怎樣調用啊?
------解决方案--------------------理解错楼主的意思了