Win a copy of Functional Reactive Programming this week in the Other Languages forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

null resultset

 
JayaSiji Gopal
Ranch Hand
Posts: 303
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am calling a stored procedure from a java program as follows:



When I run the Stored procedure, i get one record. The outparam in the above code also returns "SuCCESS". However, rs = st.getResultSet(), returns null.

What could be the reason? The same code, at exactly in a different method works perfectly fine.

Please assist.
 
venkat vanukuri
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Jayashree,

I guess one uses Result set to deal with objects returned. for example Oracle data type CURSOR.
In your case i see no reason to use result set.

I might be wrong.

Hope it helps
 
venkat vanukuri
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
one more suggestion if you have to use Result Set,
try using rs = st.execute(); rather than boolean b = st.execute();.

Hope it helps.

Regards
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic