Posted: Mon Jan 19, 2009 3:22 pm Post subject: SOLVED: ResultSet returned by invoked stored procedures
Apprentice
Joined: 20 Dec 2004 Posts: 34
Hello,
I have been trying to invoke a stored procedure using a xslt file in Datapower. This stored proc returns multiple result sets and i have not been able to configure it to be able to access the result sets being returned.
So far i have been able to execute the stored procedure using the following stylesheet, though i haven't been able to get the result sets being returned:
I have been able to call the same stored proc using message broker and was able to access all the result sets. So i know that stored proc is executing correclty.
I might be able to use the <dp:sql-execute> element instead of the dp:sql-execute() function. This allows me to specify the parameter types and their respective directions. But this still does not tell me how to access the result sets being returned.
I would appreciate any suggestions. _________________ Prithvi
The problem was not with the style sheet. This <dp:sql-execute> element does not support result sets in 3.6.1 version of datapower. Once we upgraded to 3.7.2 the result sets were returned just fine. _________________ Prithvi
Posted: Mon May 23, 2011 10:20 pm Post subject: ResultSet returned by invoked stored procedures
Acolyte
Joined: 30 Jan 2007 Posts: 66
Can you tell me how you were able to access multiple results sets generated by a stored procedure in Message Broker.
I am using version 7 of MB and when I call a stored procedure that returns multiple result sets, I am able to access only the first result set. I am using hasMoreResults() and getREsultSet() methods to process the resultsets using a jdbc type 4 driver. Any thoughts?
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum