
November 30th, 2011, 10:36 PM
|
|
Registered User
|
|
Join Date: Nov 2011
Posts: 1
Time spent in forums: 52 m 59 sec
Reputation Power: 0
|
|
|
Anyone able to help?
I am having a slight problem with an sql procedure im trying to create, keep getting an error saying "encountered ;, while expecting the following: if" could anyone help?
CREATE OR REPLACE PROCEDURE CustOrders(
iCust IN NUMBER
)
AS
CurrentRow OrderCursor%ROWTYPE;
oCompany VARCHAR2(15);
CURSOR OrderCursor IS
SELECT Description, Amount
FROM Products, Orders
WHERE iCust = Cust;
BEGIN
SELECT Company
INTO oCompany
FROM Customers
WHERE iCust = CustNum;
IF SQL%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE ("Customer " || oCompany || " was not found.");
ELSE IF SQL%FOUND THEN
SELECT OrderNum
FROM Orders
WHERE CustNum = Cust;
IF SQL%NOTFOUND THEN
DBMS_OUTPUT.PUT_LINE(oCompany || " has no orders recorded.");
ELSE IF SQL%FOUND THEN
DBMS_OUTPUT.PUT_LINE("Orders For " || iCust || oCompany);
DBMS_OUTPUT.PUT_LINE("Description Amount");
FOR CurrentRow IN OrderCursor
LOOP
DBMS_OUTPUT.PUT_LINE (CurrentRow.Description || " " || CurrentRow.Amount);
END LOOP;
END IF;
END IF;
END;
/
SHOW ERRORS
|