Reputation: 373
I executed the following:
CREATE OR REPLACE PROCEDURE DISCOUNT
(PHAR IN VARCHAR2,
TRADE IN VARCHAR2,
EFFECT IN VARCHAR2,
FORMULAE IN VARCHAR2,
PRICE IN NUMBER,
DISCOUNT IN NUMBER) IS
DECLARE
PHAR VARCHAR2(30), TRADE VARCHAR(30), EFFECT VARCHAR(250), FORMULAE VARCHAR2(50),
PRICE NUMBER(7,2);
BEGIN
SELECT TRADE IN TRADENAME WHERE PHARNAME = PHAR AND LISTPRICE = PRICE;
END DISCOUNT;
ok and after "Enter" button, i typed this
EXECUTE DISCOUNT;
and this is what i get:
2
3
4
Is that an error??
In case it's needed, here is the DISCOUNT tale structure:
PHARNAME NOT NULL VARCHAR2(30)
TRADENAME NOT NULL VARCHAR2(30)
SIDEEFFECT VARCHAR2(250)
FORMULA VARCHAR(50)
LISTPRICE NUMBER(7,2)
Upvotes: 0
Views: 676
Reputation: 373
I've figured out what those
2
3
4
after the lines EXECUTE DISCOUNT
they're command lines. i've to type one line at a time for stored procedure
SQL> BEGIN DBMS_OUTPUT.PUT_LINE('Hello!');
2 END;
3 /
Upvotes: 1