title: Making a search bar manually WITHOUT interactive report. (Oracle APEX)
body: <p>I am trying to make an application completely manually without using any interactive reports or generated PL/SQL. Everything is working at the moment but I am stumped when it comes to the search bar and I can't find anything online to help me. </p>
  
  <p>I have a classic report called 'Browse Job Vacancies' and a 'Search' button; I also have the 'C1_JOB_TITLE_ITEM' search bar and a page process called 'Search'.</p>
  
  <p>In the process I have this code:</p>
  
  <pre><code>SELECT 
      JOB_CODE, 
      JOB_TITLE, 
      JOB_DESCRIPTION, 
      SITE_NAME, 
      EMAIL_ADDRESS, 
      TELEPHONE_NUMBER, 
      SALARY, 
      START_OF_PLACEMENT, 
      APPLICATION_METHOD, 
      APPLICATION_CLOSING_DATE
  FROM JOB
  WHERE upper(job_title) = upper(:C1_JOB_TITLE_ITEM);
  </code></pre>
  
  <p>I am getting this error: </p>
  
  <blockquote>
    <p>ORA-06550: line 1, column 64: PLS-00428: an INTO clause is expected in this SELECT statement</p>
  </blockquote>
  
  <p>So I created this code:</p>
  
  <pre><code>DECLARE temp_row char;
  BEGIN
      SELECT 
          JOB_CODE, 
          JOB_TITLE, 
          JOB_DESCRIPTION, 
          SITE_NAME, 
          EMAIL_ADDRESS, 
          TELEPHONE_NUMBER, 
          SALARY, 
          START_OF_PLACEMENT, 
          APPLICATION_METHOD, 
          APPLICATION_CLOSING_DATE
      INTO temp_row
      FROM JOB
      WHERE job_title = :C1_JOB_TITLE_ITEM;
  END;
  </code></pre>
  
  <p>Here I am getting this error:</p>
  
  <blockquote>
    <p>ORA-06550: line 13, column 16: PL/SQL: ORA-00947: not enough values</p>
  </blockquote>
  
  <p>I am completely stumped on what to do at this point so any help at all is greatly appreciated. Sorry if I'm not being detailed enough this is my first time writing in Stack Overflow.</p>