动态执行SQL的问题

[gexiujun]

stmt_ := '
BEGIN
inventory_part_in_stock_api.move_part(:pallet_id_list,
:contract_,
:part_no_,
:configuration_id_,
:location_no_,
:lot_batch_no_,
:quantity_,
:quantity_reserved_,
:move_comment_,
:order_no_
);

END;';
EXECUTE IMMEDIATE stmt_
USING
OUT pallet_id_list_,
IN rec_.contract,
IN info_.part_no,
IN '*',
IN '02',
IN '*',
IN info_.qty_send,
IN 0,
IN info_.remark,
IN NULL；
请问这个在 IN 的时候不能用NULL吗？

[chanet]

try it:
EXECUTE IMMEDIATE stmt_
USING
OUT pallet_id_list_,
IN rec_.contract,
IN info_.part_no,
IN '*',
IN '02',
IN '*',
IN info_.qty_send,
IN 0,
IN info_.remark,
IN ''；