File made by Drew Hengehold Function created. No errors. Function created. No errors. Function created. No errors. Function created. No errors. ========Testing item_sold======== +-+-+-+-+-+-+-+-+-+ (Test 1 of item_sold) Should output: employee id = 000001, item id = 001, and customer id = 200001 Additionally, the sale_item table should have 2 less black teas, and the sale table should have one more entry +-+-+-+-+-+-+-+-+-+ Customer id is: 200001 Item id is: 001 Employee id is: 000001 got here BEGIN :result_var := sell('coulsen','black', 2,'higgins'); END; * ERROR at line 1: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 1 RESULT_VAR -------------------------------------------------------------------------------- (Test 2 of item_sold) Should output: employee id = -1, item id = 001, and customer id = 200001 The output should be transaction failed, and no updates should be made to the table so black tea should be 28, and the last sale number should be 11 +-+-+-+-+-+-+-+-+-+ Customer id is: 200001 Item id is: 001 Employee id is: 000001 got here PL/SQL procedure successfully completed. RESULT_VAR -------------------------------------------------------------------------------- 2 of black was ordered