title: Need help in execute immediate update query
body: <p>I have this query and it's not updating into the database. The given "where" clause is valid. When I run the query independently, it works fine but in this Procedure it's not working. There is no exception or no error. Could you guys help me in figuring out where the problem is?</p>
  
  <pre><code>EXECUTE IMMEDIATE 'UPDATE  ' || dest || ' SET COUNTRY_CODE = :v1 WHERE col_id = :v2'
            USING l_vc_CountryCode, l_vc_ColId;
  
  if SQL%ROWCOUNT &gt; 1 THEN
            inserts := inserts + 1;
            counter := counter + 1;
            IF counter &gt; 500 THEN
              counter := 0;
              COMMIT;
            END IF;
          END IF;
  </code></pre>
  
  <p>I didn't write the commit code before. Just to clarity.</p>