Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I created this package head SQL> CREATE OR REPLACE PACKAGE pointOfSal AS 2 -- Procedure to add new customer 3 PROCEDURE add_customer ( 4 customer_name
I created this package head
SQL> CREATE OR REPLACE PACKAGE pointOfSal AS 2 -- Procedure to add new customer 3 PROCEDURE add_customer ( 4 customer_name IN VARCHAR2, 5 customer_phone IN VARCHAR2 6 ); 7 -- Cursor to check if customer exists 8 CURSOR checkExistingCustomer (customer_name IN VARCHAR2) IS 9 SELECT customer_name 10 FROM customers 11 WHERE customer_name = customer_name; 12 END pointOfSal; 13 /
and it worked
but my package body wont work, can someone tell me why?
it says Package Body created with compilation errors.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started