title: How to call Stored Procedure and prepared statement
body: <p>In the below code I want to call one stored procedures and execute one Query. I am facing error at <code>statement.executeUpdate();</code> Please help in fixing it. I am not sure where it going wrong.</p>
  
  <pre><code>public void Dbexe() {
  
      Connection connection;
      connection = DatabaseConnection.getCon();
       CallableStatement stmt;
      try {
          stmt = connection.prepareCall("{CALL optg.Ld_SOpp}");
          stmt.executeUpdate();
          stmt.close();
      } catch (SQLException e1) {
          // TODO Auto-generated catch block
          e1.printStackTrace();
      }
  
       System.out.println("Stored Procedure executed");
  
       //PreparedStatement statement = null;
      // ResultSet rs = null;
  
      try{
  
  
       PreparedStatement statement;
      try {
          statement = connection.prepareStatement("MERGE INTO OPTG.R_VAL AS TARGET USING" + 
                ........... +
               "");
  
           statement.executeUpdate(); //Here the exception is thrown  
           statement.close();
  
           connection.commit();
           connection.close();
  
  
      } catch (SQLException e) {
          // TODO Auto-generated catch block
          e.printStackTrace();
      }   
  
      // statement = connection.prepareStatement(query);
  
       //statement.close();
  
      }
  
      finally{
  
          System.out.println("Data is copied to the  Table");
  
              }    
  
   }
  </code></pre>