How to call an oracle stored procedure to return one param

Hi,
I do have the similar problem and could not get straight forward solution for stored procedures.
Later I solved by writing the groovy script where you can return any number of result sets/basic types as out Parameters
and store the result at Properties Step (for basic types) or in Excel/CSV file for Result Sets.
You can refer:
1. http://groovy.codehaus.org/Database+features
2. http://docs.oracle.com/cd/E17952_01/ref ... lable.html
Hope it helps.