CODEWITHSUNDEEP
oracle-databaseplsql
Preeyah
Preeyah

Reputation: 373

PL/SQL Cannot Execute Stored Procedure

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

Answers (1)

Preeyah
Preeyah

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

Related Questions