PLSQL中的SQL语句引用变量
画水 2014-05-19 03:31:02 各位大侠,下面的PLSQL语句里面,前面可以输出变量stockin_no的值,但是到后面更新的时候却为空了,不知道为什么,小弟第一次写PLSQL,帮个忙吧,谢谢
IF r1.DATA_TYPE = 'NML' AND r1.DATA_SOURCE = 'WMS' THEN
dbms_output.put_line('-----');
dbms_output.put_line(stockin_no);
dbms_output.put_line('-----');
UPDATE
PMS_TRN_SERIAL_LIST
SET
-- STOCKIN_NO = stockin_no,
-- STOCKIN_NO = 'shu',
STOCKIN_NO = nvl(trim(stockin_no),'sato'),
WMS_NYKA_SEND_FLG = '9',
WMS_NYKA_SEND_DATE = SYSDATE,
UPD_DATE = SYSDATE
WHERE
OWNER_CODE = r1.OWNER_CODE
AND
WAREHOUSE_CODE = r1.WAREHOUSE_CODE
AND
NYKA_PALLET_NO = r1.PALLET_NO
AND
WMS_NYKA_SEND_FLG = '0'
AND
RECEIPT_FLG = '3';
END IF;