Problem in CallableStatement

[Meet Gaurav]

Am trying to call this one..

CallableStatement calll = conn.prepareCall("{call test(?,?,?,?,?)}");
...
...
boolean result = calll.execute();

In side this procedure am updating some tables. After executing this statement am getting the result as false. But the procedure is executed sucessfully and all the tables are updated correctly..

Please assist Me.

[Raghavan Muthu]

Originally posted by Meet Gaurav:


In side this procedure am updating some tables. After executing this statement am getting the result as false. But the procedure is executed sucessfully and all the tables are updated correctly..

By looking at the Java Doc of the execute() method of PreparedStatement class, it says the following.

     The execute method returns a boolean to indicate the form of the first result. 
You must call either the method getResultSet or getUpdateCount  to retrieve the result; 
you must call getMoreResults to move to any subsequent result(s).
 
    [B]Returns:[/B]
        true if the first result is a ResultSet object; [I][B]false[/B] if the first result is an update count or there is no result[/I]

It does NOT really indicate a *failure* of execution.

Hope this helps!
[ October 31, 2008: Message edited by: Raghavan Muthu ]