#
/** File will not work in PHPMyAdmin you need to import files fruitRoutineCreate.sql, and then fruitRoutineTest.sql @author Professor Tom DeDonno fruitRoutineCreate.sql.html has.. function getImageURL( fid smallint) procedure orderInvoiceVerySimple( orderID ) no PLSQL block example procedure orderInvoice( orderID ) full featured orderInvoice note fruitShared.orderInvoiceSimple( orderID ) list orderID,customerID and line items with submit we cannot list startDate, or shipDate set when file is run fruitRoutineTest.sql.html tests the function and two procedures @date modified 8/2015 Note in good sw design we avoid absolute paths we either set a system variable i.e., premiere=rootfolder or use all relative paths */ source /home/premiere/public_html/fruitRoutineCreate.sql.html; source /home/premiere/public_html/fruitRoutineTest.sql.html;