Decrease the stock level of the item by the ordered quantity.
将该产品的库存水平减去订购的数量。
For each item in the order, the procedure checks if the quantity in stock can fulfill the quantity ordered.
对于订单中的每一项,过程将检查库存数量是否满足订购数量。
If the available quantity from the stock table for the requested item is less than the quantity ordered, the transaction rolls back to the neworder savepoint.
如果所请求商品在stock表中的可用数量小于订购的数量,那么事务将回滚到neworder保存点。
应用推荐