title: PLS-00103: Encountered the symbol "(" when expecting one of the following:
body: <p>I am trying to retrieve a customer id pk column from a report page to a form page that gets automatically incremented whenever the user moves from the report page to the form page using oracle application express.So i am trying to create a trigger that returnns a number having the value of the final row along with a +1 increment to it. However i get this error</p>
  
  <pre><code>Error at line 8: PLS-00103: Encountered the symbol "(" when expecting one of the following:
     , from
  6. INTO number
  7. FROM (SELECT a.cust_id, max(cust_id) over() as max_pk FROM customer a)
  8. WHERE cust_id = max_pk;
  9. number:=(cust_id+1);
  10. END;
  </code></pre>
  
  <p>This is my PL/SQL procedure.</p>
  
  <pre><code>CREATE OR REPLACE FUNCTION cust_id_incremental(cust_id IN number)
  RETURN number;
  
  
  BEGIN
  
  SELECT cust_id
  INTO number
  FROM (SELECT a.cust_id, max(cust_id) over() as max_pk FROM customer a)
  WHERE cust_id = max_pk;`enter code here`
  number:=(cust_id+1);
  
  END;
  </code></pre>