I am attempting to run this PL/SQL command and get this error:

Warning: Procedure created with compilation errors.

Here is the code

CREATE OR REPLACE PROCEDURE DISPLAY_CUSTOMER_INFO(P_CUSTOMER NUMBER) IS



V_CUSTREC CFUSTOMERS%RWTYPE;
V_SALES_REP VARCHAR2(25);
V_ORDERS_CNT NUMBER(6);
V_ORDERS_AMT NUMBER;

BEGIN

BEGIN
SELECT *
INTOV_CUSTREC
FROM CUSTOMERS
WHERE CUSTOMER_ID = P_CUSTOMER;
EXCEPTION
WHEN NO_DATA_FOUND THEN
RAISE_APPLICATION_ERROR(-20000, 'CUSTOMER DOES NOT EXIST');
END;

SELECT FIRST_NAME || '' || LAST_NAME
INTO V_SALES_REP
FROM EMPLOYEES
WHERE EMPLOYEE_ID = V_CUSTREC.SALES_REP_ID;

SELECT COUNT(*)
INTO V_ORDERS_CNT
FROM ORDERS
WHERE CUSTOMER_ID_ = P_CUSTOMER;

SELECT SUM(TOTAL_AMOUNT)
INTO V_ORDERS_AMT
FROM ORDER_LINES
WHERE ORDER_ID IN (SELECT ORDER_ID
FROM ORDERS
WHERE CUSTOMER_ID = P_CUSTOMER);

DBMS_OUTPUT.PUT_LINE('CUSTOMER NAME: ' ||
V_CUSTREC.FIRST_NAME||' '||
V_CUSTREC.LAST_NAME);
DBMS_OUTPUT.PUT_LINE('CUSTOMER PHONE: ' || V_CUSTREC.PHONE);
DBMS_OUTPUT.PUT_LINE('CUSTOMER STATUS: ' || V_CUSTREC.STATUS);
DBMS_OUTPUT.PUT_LINE('NUMBER OF ORDERS: ' || V_ORDERS_CNT);
DBMS_OUTPUT.PUT_LINE('ORDERS AMOUNT: ' || V_ORDERS_AMT);
END;


Thanks in advanced

D.j

Look at the declaration section, you have:
V_CUSTREC CFUSTOMERS%RWTYPE;

it should probably read as follows:

V_CUSTREC CUSTOMERS%ROWTYPE;

Good luck
dlf

---
D.j wrote: