• Post Reply Bookmark Topic Watch Topic
  • New Topic

How to create Multiple Resultset in oracle  RSS feed

 
Rajendra Prakash
Ranch Hand
Posts: 293
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
How to create multiple resultset normally and how to create ResultSet in Stored procedure.
Should i create temporary tables. if so how to create that.
 
Nigel Bartlet-Ren
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You can return a cursor from a stored procedure, which allows you to return a full set of rows in a single row of your Java result set.
I found the following resource which gives you a worked example : http://www.oracle-base.com/articles/misc/UsingRefCursorsToReturnRecordsets.php

Nigel
 
Rajendra Prakash
Ranch Hand
Posts: 293
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Cursor ok. can we create multiple resultset normally and also how to create multiple resultset
in stored procedure
 
Don't get me started about those stupid light bulbs.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!