title: Stored Procedure Returns null to Result Set
body: <p>while working on JDBC, I got an issue I have created a table in mysql which contains the employee info Employee_Id,Name,City,Salary and Year_of_joining and i also created a stored procedure to the same database which takes two inputs and update the salary of employees base on the year of joining. Here is the Stored Procedure:</p>
  
  <pre><code>CREATE PROCEDURE proc(IN var1, IN var2)
  BEGIN
    UPDATE "TABLE" SET Salary=var1+Salary WHERE Year_of_Joining= var2
  END
  </code></pre>
  
  <p>Now i Created a database connection through java to mysql database (That connection is being established successfully)</p>
  
  <p>But now, When i execute the query after creating the CallableStatement object and try to convert the current result of callable object to Result set i get null . Please help me with this.
  Here is the Code:</p>
  
  <pre><code>// Creates connection with java:
  Connection con= DriverManager.getConnection(url,username,pswrd);
  
  // Now Calling the Stored procedure from mysql
  CallableStatement col =  con.prepareCall("{call proc(?,?)}");
  
  // gave values to the procedure
  col.setDouble(1,20000);
  col.setInt(2,2012);
  col.execute();
  
  // Returning Result set=null
  ResultSet rs = col.getResultSet();
  </code></pre>