• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Multiple Result Sets

 
Dale DeMott
Ranch Hand
Posts: 515
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Does Oracle have the ability to do Multiple Result Sets? Has anyone done this or something similar w/Oracle?
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34669
366
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dale,
Yes. Oracle allows multiple resultsets. I've done this in Sybase, but not in Oracle. It's the same idea in both databases though.

This article walks you through what to call.
 
Purushoth Thambu
Ranch Hand
Posts: 425
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am not sure about Jeanne comment. Oracle do support returning multiple resultset from a stored procedure but it has to be a REFCURSOR type. The standard API's for returning multiple resultsets like getMoreResults do not a expected implementation with orace jdbc driver.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34669
366
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I defer to Purushothaman. Like I said, I haven't done this in Oracle. I just assumed it would be the same as Sybase.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic