Write a script that creates and calls a stored procedure named test. this procedure should include these statements coded as a transaction:

insert into orders values
(default, 3, '10.00', '0.00', null, 4,
'american express', '378282246310005', '04/2013', 4);

select last_insert_id()
into order_id;

insert into order_items values

(default, order_id, 6, '415.00', '161.85', 1);

insert into order_items values

(default, order_id, 1, '699.00', '209.70', 1);

here, the last_insert_id function is used to get the order id value that