Hello I am trying to create a procedure using Oracle My SQL Developer

This is my table

```
CREATE TABLE Product(
    ProductID int, 
    ProductName varchar2(100),  
    ProductFinish varchar2(100), 
    ProductStandardPrice int, 
    ProductLineID int, 
    PRIMARY KEY (ProductID));

```

The data being inserted 

```
    INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (1, 'End Table', 'Cherry', 175, 1);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (2, 'Coffee Table', 'Natural Ash', 200, 2);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (3, 'Computer Desk', 'Natural Ash', 375, 2);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (4, 'Entertainment Center', 'Natural Maple', 650, 3);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (5, 'Writers Desk', 'Cherry', 325, 1);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (6, '8-Drawer Desk', 'White Ash', 750, 2);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (7, 'Dining Table', 'Natural Ash', 800, 2);
INSERT INTO Product (ProductID, ProductName, ProductFinish, ProductStandardPrice, ProductLineID) VALUES (8, 'Computer Desk', 'Walnut', 250, 3);

```

And the procedure im trying to create

```
CREATE PROCEDURE ProductLineSale
AS
SELECT *,
CASE WHEN ProductStandardPrice >= 400 THEN (ProductStandardPrice * 0.9)
ELSE (ProductStandardPrice * 0.85)
END AS SalePrice
FROM product
GO;

EXEC ProductLineSale;

```

At Select \*
I am getting that error. Would you please offer help. I'm still new to this.

Edit: The procedure that was proposed works, however, I am still quite stuck. 
The procedure is in an invalid state so I cannot call it and 
I am trying to access the database from JSP via Netbeans. 

Forgive my many mistakes, and here is my code from Netbeans

```
<%@ page import = "java.sql.*"%>
<%@ page import = "java.io.*"%>
<% Class.forName("oracle.jdbc.driver.OracleDriver");%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title>JSP Page</title>
    </head>
    <body>
        <h1>JSP Page connected successfully!</h1>
        <%

            String url = "jdbc:oracle:thin:@129.7.240.3:1521:ORCL";

            Connection basic = DriverManager.getConnection(url, "myname", "myname#");

            Statement statement = basic.createStatement();
            ResultSet result = statement.executeQuery("SELECT * FROM myname.PRODUCT");

        %>

        <table width="95%" border="0" cellspacing="1" cellpadding="5" align="center" bgcolor="#999999">
            <TR>
                <TH bgcolor='#DAA520'> <font size='2'/>ProductID</TH>
                <TH bgcolor='#DAA520'> <font size='2'/>ProductNAME</TH>
                <TH bgcolor='#DAA520'> <font size='2'/>ProductFINISH</TH>
                <TH bgcolor='#DAA520'> <font size='2'/>ProductSTANDARDPRICE</TH>
                <TH bgcolor='#DAA520'> <font size='2'/>ProductLINEID</TH>
            <TR>
                <% while (result.next()) {%>
            <TR>
                <TD> <font size='2'/><center><%= result.getString(1)%></center<>/TD> 
                call ProductLineSale();
        </TR>

        <% }%>
    </table>
    <h1>Table supposed to be above this<h1>
</body>
</html>

```

Many Thanks