This week's book giveaways are in the Refactoring and Agile forums.
We're giving away four copies each of Re-engineering Legacy Software and Docker in Action and have the authors on-line!
See this thread and this one for details.
Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Java stored procedures and collections(ORCL)

 
Ricardo Riveros
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi all, i'm new to this forum and had a question.
I'm writing Java stored procedures for Oracle 10g and had a question.
Is there anyway a java stored procedure/function can return a collection that contains value objects that I created ?

Basically in the java stored procedure I want to execute the same query(with different parameters) inside a loop and create a collection of Value objects created from each ResultSet. How would I go about passing this back to the calling client ?
 
venkat vanukuri
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I think you can pass collection as an object to calling client from Stored procedure. Its possible with Oracle data type CURSOR. example:

.
.
callStmt.registerOutParameter(index number, OracleTypes.CURSOR);
.
.
ResultSet rs = callstmt.getObject(index number);
while(rs.hasnext()){
// construct VO here
}
.
.
.
Hope it helps,
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic