How to call stored procedure in birt report desing(eclipse)

I have a dataset with query, apart from the resulting query columns i need another column which has to show the price of one of the column of query. So that i need to pass the value of the column and get the price while constructing the report. Pls help me. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>BEGIN
SELECT PROD_PRICE FROM INV_PROD_PRICE_DFN A WHERE MATCODE=:MATCODE
AND NVL(VLD_FROM_DT,TRUNC(SYSDATE))<=TRUNC(SYSDATE)
AND NVL(VLD_TO_DT,TRUNC(SYSDATE))>=TRUNC(SYSDATE)
AND ROWNUM=1;
END;</pre>
 
Here :MATCODE is the resulting column of query (select matcode,.,<>,. from table2 where ...) 
 
<> how to pass matcode to this function/procedure from the query or from another way. 
 
 
Is there any way to do that through Property Binding of dataset?

Find more posts tagged with

Comments

mwilliams

So, you want to pass a row value from your query to a stored procedure? If so, you should be able to create a stored procedure query with a ? in place of where you'd call matcode as the parameter. Then, you'd embed a table from this dataSet into a table of the dataSet that brings in the matcode values. If you select the inner table and select its binding tab in the property editor, you'd see a button "dataSet parameter binding". If you select that, you could assign the row value from your select dataSet to your stored procedure dataSet parameter. Hope this makes sense. Let me know if I'm misunderstanding.