动态执行SQL的问题

Question

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_.re,
               IN NULL；
请问这个在 IN 的时候不能用NULL吗？

Answer 1

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_.re,
               IN ''；