Question: 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?

I created this package head SQL> CREATE OR REPLACE PACKAGE pointOfSal AS

it says Package Body created with compilation errors.

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!

PL/SQL Auction Program 1. Create a user xyz, who is the owner of the auction. Create the schema, and package. 2. Create users x1 and x2 who are the participants in the auction. They will need acces...

Oracle 11g PL/SQL question. The tables needed can be created with the c10_BBcreate.sql listed below. Using Dynamic SQL to create a procedure named add_row_sp for inserting a row into a table with...

these are the querys CREATE OR REPLACE FUNCTION status_desc_sf (p_stage IN NUMBER) RETURN VARCHAR2 IS lv_stage_txt VARCHAR2(30); BEGIN IF p_stage = 1 THEN lv_stage_txt := 'Order Submitted'; ELSIF...

Oracle 11g PL/SQL question. The tables needed can be created with the c10_BBcreate.sql listed below. Question: Create a stored function called ORDER_COUNT_SF to retrieve the total number of orders in...

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

-- ************************************************************* -- This script creates the database -- for Labs 4-7 based on OM (Order Management) database -- **REVISED by PRP to remove some orders...

QUESTIONS TO BE ANSWER IN ENGLISH LANGUAGE a brief analysis in 200-400 words in which you do the following: Explain what methods the leaders used to measure organizational performance. Were their...

2. Cost-Benefit Analysis Spreadsheet/ Budget 3. Indated acenmontinne dno... 2. Complete the Cost-Benefit Analysis (include figures for at least three years) -inancial Analysis tor Project Name This...

Ralph Co. manufactures products on a job-order basis. Job 4 is an order for 100 units. It requires $3,000 direct materials, $1,000 direct labor, and $1,500 overhead applied based on 150% the direct...

a) Did the red dye molecules stay close to each other and move as a group around the simulation If not, describe the distribution of the molecules at the end of the simulation

Which category of short-term financing does using a credit card fall into? Multiple choice question. Pledging and factoring Trade credit Short-term loans Commercial paper

Required information Problem 21-1A Preparing and analyzing a flexible budget LO P1, A1 [The following information applies to the questions displayed below.] Phoenix Company's 2019 master budget...

LAST WORD Explain how civil wars, population growth, and public policy decisions have contributed to periodic famines in Africa.

KEY QUESTION If we compare the betas of various investment opportunities, why do the assets that have higher betas also have higher average expected rates of return?

LAST WORD Suppose that a tax cut involves two alternative schemes: ( a ) a $2 tax cut or tax rebate for each of the 10 people in the breakfast club, or ( b ) a tax savings for each of the 10 in...