in case of CallableStatement, execute() method does now execute any SQL, rather it executes PL/SQL procedure/function. In this case, CallableStatement.execute() neither have ResultSet within the CallableStatement nor an UpdateCount. You should retrieve the out parameter using CallableStatement.getXXX() method. That is why you are having FALSE return value and the returned resultset is NULL.
Hopefully this clarifies your query.
posted 11 years ago
so does it mean that the execute() method of CallableStatement is just for merely executing stored procedures or functions and the return type doesn't matter or never used. Aren't there any use-cases where one needs to check the status of execute method and then decide further proceedings?