The example program goes through the items table to fulfill orders from the stock table.
示例程序遍历 items 表,从 stock 表履行订单。
The item_in_stock procedure above identifies if a particular item is in stock and if so, deletes it from the stock table.
上面的item_in_stock过程检查某个特定项是否位于库存中,如果是的话,那么将它从stock表中删除。
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保存点。
应用推荐