Calling Stored Procedure from BIRT

maximo2011

Hi

I am creating a report that needs to execute a stored procedure created in maximo schema in oracle database. The procedures computed data and writes it to a temp table. The report will read data from that table. I am unable to execute the procedure from BIRT report.

I came through this post before posting here but i am unable to come up to correct syntax. Please help me out of this. I have spending days over this now.

http://www.birt-exchange.org/org/forum/index.php/topic/18023-can-we-use-stored-procedure-dataset-in-birt-for-maximo/page__s__904b4379149d24067d191d3878cda87d

Thanks in advance!

NEWUSER01

We have tried out this option and you would need to call the Oracle SP like a function in BIRT report. Here you just need to pass the input parameters to the SP which will execute the SP and write the data to temp table. Then have another dataset which will be executed to fetch the data from the temp table.

select STORED_PROCEDURE(param1,param2) as temp from dual

Hope this helps