title: Oracle Apex 5: Procedure not working for counter?
body: <p>I'm trying to create a page counter. everytime someone enters a page a procedure is executed. 1 is added to the column <code>check_count</code>. Unfortunately Oracle Apex 5 is saying </p>
  
  <blockquote>
    <p>ORA-24344: success with compilation error.</p>
  </blockquote>
  
  <p>Why do you think that is?</p>
  
  <pre><code>CREATE OR REPLACE PROCEDURE check_counter(person IN varchar2) IS
  count pageTable.check_count%type;
  countTwo pageTable.check_count%type;
  BEGIN
  SELECT check_count INTO count FROM pageTable
   WHERE person = pageTable.person_name;
   countTwo := count + 1;
   INSERT INTO  pageTable (check_count)
   VALUES(countTwo);
  END;
  </code></pre>