I have written one method in the ApplicationModule. In this method I am calling a stored procedure which returns a cursor and storing the cursor in a resultset. While trying to get the result set in a VO, the resultSet is giving null. rs.next() is returning "false". But it should return "true".The code is given below:
This code looks ok.
Check your input parameter value and also test function result for the same parameter directly in db.
When you test this function in db, use the same db user as your application(maybe user doesn't have required grants, some lookup tables are not initialized, etc.)