title: Error report: Missing IN or OUT parameter at index: : 1. How can I fix that?
body: <pre><code>set serveroutput on;
  
  Declare
    cursor emp_cursor is select orderline.orderid, sum(product.productstandardprice * orderline.orderedquantity) AS price from orderline, Product WHERE orderline.Productid = Product.Productid group by orderline.orderid;
    emp_row emp_cursor%rowtype;
  
  Begin
    open emp_cursor;
    if (price &lt; 2,000)
  
    then price := 2,000 * 0.15:
  
    else if (price &gt;= 2,000)
  
    then price := 2,000 * 0.20; 
  
    loop
      fetch emp_cursor into emp_row;
      exit when emp_cursor%notfound;
      dbms_output.put_line(emp_row.orderid || ' ' || emp_row.price);
    end loop;
    close emp_cursor;
  
  End;
  </code></pre>