• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Oracle Stored Proc not returning ResultSet

 
Karthik Upadrasta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello fellow ranchers!

I have the following stored proc:


When I pass the a, b input params as 20061114, it returns 'Y' and 'Y' for V_TD_OK and V_SD_OK.

Now, I am trying to execute the proc from within Java Code:

 
Karthik Upadrasta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Sorry. I might have pressed some wrong key. It got posted before I completed the whole question.


Now this call:
ResultSet rset = call.getResultSet();

is returning null. It MUST return Y and Y. I do not understand why it is not able to.

Any help in this regard is much appreciated.

Thank you,
Karthik.
 
Karthik Upadrasta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
And finally, this is my query in the Hibernate config:


<sql-query name="testingProc" callable="true">
{call cus_nonwork_day_td_sd_ku(?, ?, ?, ?) }
</sql-query>
 
Karthik Upadrasta
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
This worked

 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic