Input ConditionsExpected Outcomes
sp_insertOrderProducts Table
PathStatements@product_idqtyproduct_idproduct_priceReturn ValueError MessageOutput Parameter(order_id)New Order Record(Orders Table)
11-3,
14-16,
18-19
1-4>01-4$19.95
$29.95
$39.95 or
$11.00
0N/Aorder_id+1product_id = @product_id
quantity = @quantity
unit_price = @price
order_cost = @quantity * @price
21-60,>5>0>5N/A99Invalid IDNULLN/A
31-5,7-95>05NULL99Missing priceNULLN/A
41-5,7,10-111-4>01-4$19.95
$29.95
$39.95 or
$11.00
99Unknown error condition IDNULLN/A
51-3,14-171-4<01-4any12(insert error)N/ANULLN/A