/*=====
  testing script for procedure title_total_cost

  by: Sharon Tuttle
  last modified: 2016-01-29
=====*/

prompt
prompt ************************
prompt TESTING title_total_cost
prompt ************************
prompt

spool title_total_cost_test_out.txt
set serveroutput on

prompt test passes if it shows that ISBN 0871507870 has
prompt 35 copies on hand with a total cost of $1137.5:
prompt ==========================================================

exec title_total_cost('0871507870') 

prompt
prompt test passes if it shows that ISBN 087150331X has
prompt 3 copies on hand with a total cost of $79.5
prompt =====================================================

exec title_total_cost('087150331X')
prompt

prompt
prompt test passes if it shows that there is NO title
prompt with ISBN 1313131313
prompt =====================================================

exec title_total_cost('1313131313')
prompt

spool off

-- end of title_total_cost_test.sql