Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to create Multiple Resultset in oracle

 
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic