I'm able to successfully create a Data Set using an Oracle Procedure that has an Oracle ref cursor as an output parameter using the syntax below:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>{call TEST.PKG_UTILS.GETDATALIST(?)}</pre>
<br />
However, is it possible to use an Oracle Function that returns an Oracle ref cursor in BIRT? I tried something like below but wasn't working:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>{call ? := TEST.PKG_UTILS.GETDATALIST }</pre>
<br />
I'm using BIRT 2.6.1<br />
<br />
Thanks
