Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spatial Databases With Application To GIS

Authors: Philippe Rigaux, Michel Scholl, Agnès Voisard

1st Edition

1558605886, 978-1558605886

More Books

Students also viewed these Databases questions