CREATE OR REPLACE PROCEDURE tax_cost_sp (p_state in bb_shopper.state%type, p_subtotal in bb_basket.subtotal%type, p_tax_amount out number) is select...

Create a stored procedure named TAX_COST_SP that calculates the tax on an order. The BB_TAX table contains states that require submitting taxes for Internet sales. If the state is not listed in the table, no tax should be assessed on the order. The shopper’s state in the BB_SHOPPER table and basket subtotal in the BB_BASKET table are the inputs to the procedure, and the tax amount should be returned. Create a PL/SQL block that calls the procedure TAX_COST_SP to calculate the tax for a basket. The basket number must be entered by the user. It should not be hard-coded in the program.The sample output must look exactly like this:Basket number: 6Shipped to state: VATax amount: $6.75I'm attaching what I have, but as you can see, it does not work and I am thoroughly confused. Thanks.