I was given the following code to run for testing for the procedures and functions made:

$/*$

File: chaudadeDBAS$32100$Assignment$1-4.$sql

Author: Adeem Chaudhry

Oracle Username: S$11\_$chaudade

Description: Testing Script

$*/$

$--$ Undefine variables to prompt for inputs again

UNDEFINE customer$\_$no

UNDEFINE order$\_$date

UNDEFINE part$\_$numbers

UNDEFINE order$\_$price

UNDEFINE order$\_$qty

UNDEFINE invoice$\_$date

UNDEFINE ship$\_$qty

$--$ Prompt for input

ACCEPT customer$\_$no NUMBER PROMPT 'Enter customer number: $\text{'}$;

ACCEPT order$\_$date DATE PROMPT 'Enter order date $($YYYY$-$MM$-$DD$)$: $\text{'}$;

ACCEPT part$\_$numbers CHAR PROMPT 'Enter part numbers: $\text{'}$;

ACCEPT order$\_$price NUMBER PROMPT 'Enter order price: $\text{'}$;

ACCEPT order$\_$qty NUMBER PROMPT 'Enter order quantity: $\text{'}$;

ACCEPT invoice$\_$date DATE PROMPT 'Enter invoice date $($YYYY$-$MM$-$DD$)$: $\text{'}$;

ACCEPT ship$\_$qty NUMBER PROMPT 'Enter ship quantity: $\text{'}$;

$--$ Variables

DEFINE customer$\_$no $=$ &customer$\_$no

DEFINE order$\_$date $=\text{'}$&order$\_$date'

DEFINE part$\_$numbers $=\text{'}$&part$\_$numbers'

DEFINE order$\_$price $=$ &order$\_$price

DEFINE order$\_$qty $=$ &order$\_$qty

DEFINE invoice$\_$date $=\text{'}$&invoice$\_$date'

DEFINE ship$\_$qty $=$ &ship$\_$qty

$--$ Test creating a failed order

VAR order$\_$no NUMBER;

VAR status VARCHAR$2(100)$;

EXEC store$\_$new$\_$order$($&customer$\_$no$,$ TO$\_$DATE$(\text{'}$&order$\_$date', $\text{'}$YYYY$-$MM$-$DD$\text{'}),\text{'}$&part$\_$numbers', &order$\_$price, &order$\_$qty$,$ :order$\_$no$,$ :status$)$;

PRINT status;

$--$ Test creating a correct order

EXEC store$\_$new$\_$order$($&customer$\_$no$,$ TO$\_$DATE$(\text{'}$&order$\_$date', $\text{'}$YYYY$-$MM$-$DD$\text{'}),\text{'}$&part$\_$numbers', &order$\_$price, &order$\_$qty$,$ :order$\_$no$,$ :status$)$;

PRINT status;

$--$ Display the newly created order

EXEC S$11\_150.$sh$\_$display$\_$order$($:order$\_$no$)$;

$--$ Test creating a failed invoice

VAR invoice$\_$no NUMBER;

EXEC store$\_$new$\_$invoice$($:order$\_$no$,$ TO$\_$DATE$(\text{'}$&invoice$\_$date', $\text{'}$YYYY$-$MM$-$DD$\text{'}),\text{'}$&part$\_$numbers', &ship$\_$qty$,$ :invoice$\_$no$,$ :status$)$;

PRINT status;

$--$ Test creating two invoices with partially shipped products

EXEC store$\_$new$\_$invoice$($:order$\_$no$,$ TO$\_$DATE$(\text{'}$&invoice$\_$date', $\text{'}$YYYY$-$MM$-$DD$\text{'}),\text{'}$&part$\_$numbers', &ship$\_$qty$,$ :invoice$\_$no$,$ :status$)$;

PRINT status;

$--$ Display the newly created invoices

EXEC S$11\_150.$sh$\_$display$\_$invoice$($:invoice$\_$no$)$;

$--$ Rollback

ROLLBACK;

$--$ Commit the final submission

$--$ COMMIT;

$/*$

$-----------------------$ Output begins $------------------------$

$--$ Output from executing the insert$\_$order procedure:

$-----------------------$ Output ends $------------------------$

$*/$

This is the output$/$error I get:

Error starting at line : $21$ in command $-$

BEGIN store$\_$new$\_$order$(101,2025-01-02,$ I$65009,149\mathrm{.}99,4,$ :order$\_$no$,$ :status$)$; END;

Error report $-$

ORA$-06550$: line $1,$ column $64$:

PLS$-00201$: identifier $\text{'}$I$65009\text{'}$ must be declared

ORA$-06550$: line $1,$ column $7$:

PL$/$SQL: Statement ignored

$06550.00000-$ "line $\%$s$,$ column $\%$s:

$\%$s$"$

$*$Cause: Usually a PL$/$SQL compilation error.

$*$Action:

STATUS

$--------------------------------------------------------------------------------$

Error starting at line : $25$ in command $-$

BEGIN store$\_$new$\_$order$(101,2025-01-02,$ I$65009,149\mathrm{.}99,4,$ :order$\_$no$,$ :status$)$; END;

Error report $-$

ORA$-06550$: line $1,$ column $64$:

PLS$-00201$: identifier $\text{'}$I$65009\text{'}$ must be declared

ORA$-06550$: line $1,$ column $7$:

PL$/$SQL: Statement ignored

$06550.00000-$ "line $\%$s$,$ column $\%$s:

$\%$s$"$

$*$Cause: Usually a PL$/$SQL compilation error.

$*$Action:

STATUS

$--------------------------------------------------------------------------------$

PL$/$SQL procedure successfully completed.

Error starting at line : $34$ in command $-$

BEGIN store$\_$new$\_$invoice$($:order$\_$no$,2024-05-27,$ I$65009,5,$ :invoice$\_$no$,$ :status$)$; END;

Error report $-$

ORA$-06550$: line $1,$ column $51$:

PLS$-00201$: identifier $\text{'}$I$65009\text{'}$ must be declared

ORA$-06550$: line $1,$ column $7$:

PL$/$SQL: Statement ignored

$06550.00000-$ "line $\%$s$,$ column $\%$s:

$\%$s$"$

$*$Cause: Usually a PL$/$SQL compilation error.

$*$Action:

STATUS

$--------------------------------------------------------------------------------$

Error starting at line : $38$ in command $-$

BEGIN store$\_$new$\_$invoice$($:order$\_$no$,2024-05-27,$ I$65009,5,$ :invoice$\_$no$,$ :status$)$; END;

Error report $-$

ORA$-06550$: line $1,$ column $51$:

PLS$-00201$: identifier $\text{'}$I$65009\text{'}$ must be declared

ORA$-06550$: line $1,$ column $7$:

PL$/$SQL: Statement ignored

$06550.00000-$ "line $\%$s$,$ column $\%$s:

$\%$s$"$

$*$Cause: Usually a PL$/$SQL compilation error.

$*$Action:

STATUS

$--------------------------------------------------------------------------------$

PL$/$SQL procedure successfully completed.

Rollback complete.

Attached is the schema used for the procedures and function and this script was tasked to complete the following:

Write a testing script that uses substitution parameters to perform the following:

Using substitution variables, execute the stored procedure from step #$1$ to create:

a failed order

a correct order with at least $3$ products

Execute S$11\_150.$sh$\_$display$\_$order to display your newly created order

Using substitution variables. execute the stored procedure from step #$3$ to create:

a failed invoice

two invoices using the newly created order and partially shipped products

Execute S$11\_150.$sh$\_$display$\_$invoice to display your newly created invoices