Script not executing in SQL

Question

Everytime I execute my script it just echos everything in my script and never executes it. It forms numbers on the side for the lines of code then it never lets me get out of it I have to restart all over again to try again. Here is an the code it does it after.

-- 1

CREATE OR REPLACE FUNCTION ZIP_CODE_SALES(zip_in IN VARCHAR)
  RETURN FLOAT
IS
  totalSales FLOAT;
BEGIN
  SELECT SUM(S.gross_sale_price) INTO totalSales
  FROM SALE S JOIN CUSTOMER C
  ON S.cust_ID = C.cust_ID
  GROUP BY C.zip_code 
  HAVING C.zip_code = zip_in;   
  RETURN totalSales;
END;

Kobi · Accepted Answer · 2016-12-04 10:33:53Z

1

You have to add hadd a slash/ after the end; to ensure the DML in the buffer is executed.

END;
/

answered Dec 4, 2016 at 10:33

Kobi

2,52418 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Script not executing in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related