Using a For Each Group in Tibco ActiveMatrix BusinessWorks with a Stored Procedure Return Cursor

[Tim Scoff]

I have an Oracle Stored Procedure that returns a REF CURSOR and I am pulling it into Tibco ActiveMatrix BusinessWorks 6.5 successfully. When I manually type in the record number$Get_PC_CM_ACCTS/Resultsets/ResultSet1[1]/Record1[$index]/ACCT_ID, replacing $index with a number, the data from Oracle is displayed properly. But I need to loop through the result set and process each record in the result set, exiting after the last record is processed, and count($Get_PC_CM_ACCTS/Resultsets/ResultSet1[1]) returns a 1 instead of returning the number of records in the result set.

How can I loop through the REF CURSOR result set please Using count on a SQL Query instead of a Stored Procedure Output REF CURSOR works, but the business logic is mostly in Oracle and moving it into Tibco is not a viable solution.

Thank you!

[Tim Scoff]

Changing it to a While Group Type withexists($Get_PC_CM_ACCTS/Resultsets/ResultSet1[1]/Record1[$index]/ACCT_ID) as the Condition is the solution!