title: Duplicating error message in Tabular Form APEX 5
body: <p>I have a tabular form in APEX 5 with a PLSQL Function (Return Error Text) validation type.</p>
  
  <p>When i add the following 3 rows:</p>
  
  <pre><code>Row 1 : A &amp; 2
  
  Row 2 : A &amp; 3
  
  Row 3 : A &amp; 1 -&gt; This values already exists in the database and should return an error.
  </code></pre>
  
  <p>I'm getting this:</p>
  
  <blockquote>
    <p>"A &amp; 1 already exists in database. (Row 1)"</p>
    
    <p>"A &amp; 1 already exists in database. (Row 2)"</p>
    
    <p>"A &amp; 1 already exists in database. (Row 3)"</p>
  </blockquote>
  
  <p>I want to get this:</p>
  
  <blockquote>
    <p>"A &amp; 1 already exists in database. (Row 3)"</p>
  </blockquote>
  
  <p>I'm getting more then one error which is not correct, i should get just one for row 3. I think this is because of the Execution scope properties of the validation. The only 2 options that I have are:</p>
  
  <ul>
  <li>For created and modified rows (using this)</li>
  <li>All submitted rows  </li>
  </ul>
  
  <p>I call the validation function with an array and looping through it then returning a varchar text for the validation.</p>
  
  <p>Here is my <a href="http://i.stack.imgur.com/sbJBf.png" rel="nofollow">validation code</a>:</p>