Question: Everything seems to be working fine excpet the testing code. I input the values and it gives me the following error: Error starting at line

Everything seems to be working fine excpet the testing code. I input the values and it gives me the following error:
Error starting at line : 21 in command -
BEGIN store_new_order(101,2025-01-02, I65009,149.99,4, :order_no, :status); END;
Error report -
ORA-06550: line 1, column 64:
PLS-00201: identifier 'I65009' 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, I65009,149.99,4, :order_no, :status); END;
Error report -
ORA-06550: line 1, column 64:
PLS-00201: identifier 'I65009' 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, I65009,5, :invoice_no, :status); END;
Error report -
ORA-06550: line 1, column 51:
PLS-00201: identifier 'I65009' 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, I65009,5, :invoice_no, :status); END;
Error report -
ORA-06550: line 1, column 51:
PLS-00201: identifier 'I65009' 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.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!