<p>Hi,</p>
<p>i have to call a function from oracle query where the function calls storedprocedure. Inside stored procedure doing some calculations and insrting into one table called Table1.</p>
<p>Again i need to select table1 columns to the report. how can i achieve in BIRT.</p>
<p> </p>
<p>Eg:</p>
<p>Select get_function(ID) from tableAB</p>
<p>(Get_function calls procedure (SP1 ) inside the procedure insert the records to TABLE1 based on function parameter value)</p>
<p> </p>
<p>after need use all Table 1 column data to report.</p>
<p> </p>
<p>select * from TABLE1;</p>
<p> </p>
<p>Please help me.</p>
<p> I tried with REF_CURSOR method as output type parameter. which i couldn't call from BIRT throwing error.</p>
<p> </p>
<p>Thanks,</p>
<p>Selvamani</p>
