關於單行游標的數據返回問題!!

Question

SELECT TNT_TAX_TYPE INTO BVT_TAX_TYPE_A,
            TNT_DEPT INTO DEPT_A   
    FROM ZGTADMIN.BX_TENANT
    WHERE TNT_COMPANY=:MYOLD.TNB_COMPANY  AND
      TNT_TENANT=:MYOLD.TNB_TENANT  AND
      TNT_CONTRACT=:MYOLD.TNB_CONTRACT  AND
      TNT_SUB_CONTRACT=:MYOLD.TNB_SUB_CONTRACT;我這樣寫錯在那裡?應該怎麼改?

Answer 1

SELECT TNT_TAX_TYPE ,
            TNT_DEPT INTO BVT_TAX_TYPE_A, DEPT_A   
    FROM ZGTADMIN.BX_TENANT
    WHERE TNT_COMPANY=:MYOLD.TNB_COMPANY  AND
      TNT_TENANT=:MYOLD.TNB_TENANT  AND
      TNT_CONTRACT=:MYOLD.TNB_CONTRACT  AND
      TNT_SUB_CONTRACT=:MYOLD.TNB_SUB_CONTRACT;

Answer 2

SELECT TNT_TAX_TYPE ,
TNT_DEPT INTO BVT_TAX_TYPE_A, DEPT_A
FROM ZGTADMIN.BX_TENANT
WHERE TNT_COMPANY=:MYOLD.TNB_COMPANY AND
TNT_TENANT=:MYOLD.TNB_TENANT AND
TNT_CONTRACT=:MYOLD.TNB_CONTRACT AND
TNT_SUB_CONTRACT=:MYOLD.TNB_SUB_CONTRACT
and rownum=1;