title: Update and delete in oracle using java
body: <p>I have a table named bcfsite with a field named activestate.</p>
  
  <pre><code>update bcfsite set activestate = 1 where bscname like '%B361Z%'
  </code></pre>
  
  <p>When I run the above query SQLPlus or Oracle SQL Developer, it works fine without any problems, but when I run it in Java using this code:</p>
  
  <pre><code>String sqlstrString = "update bcfsite 
                         set activestate = 0 where bscname like '%B361Z%' ";
  PreparedStatement ps = d.prepareStatement(sqlstrString);
  ResultSet rs = ps.executeUpdate();
  </code></pre>
  
  <p>or this code :</p>
  
  <pre><code>ResultSet rs = DBConnection.RunStatement(sqlstrString, d);
  </code></pre>
  
  <p>My program pends and doesn't pass the update statement.</p>
  
  <p>I changed the table and column and tried delete instead of update but still I see the same problem.</p>