title: Oracle view ORA-00907: missing right parenthesis
body: <pre><code>SELECT 
      SALE.SaleID,
      SALE.SaleDate,
      CUSTOMER.CustomerID, 
      FIRSTNAMEFIRST(Customer.FirstName, Customer.LastName),
      SALE_ITEM.SaleItemID,
      SALE_ITEM.ItemID,
      ITEM.ItemDescription, 
      ITEM.ItemPrice
  FROM CUSTOMER
  INNER JOIN SALE ON CUSTOMER.CustomerID = SALE.CustomerID
  INNER JOIN SALE_ITEM ON SALE.SaleID = SALE_ITEM.SaleID
  INNER JOIN ITEM ON SALE_ITEM.ITEMID = ITEM.ItemID
  </code></pre>
  
  <p>Even when I test the view it'll show the correct query results but I can't figure out error ORA-00907.</p>
  
  <p>Function definition </p>
  
  <pre><code>CREATE OR REPLACE FUNCTION FIRSTNAMEFIRST 
      ( FIRSTNAME IN VARCHAR2, LASTNAME IN VARCHAR2 ) RETURN VARCHAR2
  AS 
  BEGIN
      RETURN TRIM(FIRSTNAME) || ', ' || TRIM(LASTNAME);
  END;
  </code></pre>