Oracle Stored Procedure

[ramandeep1980]

Hi Sherman and Everyone,

Can someone mention clearly how can I use Oracle  Stored Procedure in Jasper Reports.No Where it is mentioned clearly. Most of the links provided for downloading of some JAR file which may solve the purpose is not working. I have checked in Latest edition of  ultimate guide for jasper reports too but just the name of stored procedure is there, nothing helpful though.

I am working in iReport 3.5.3 version.

Kindly let me know how to move ahead

Regards,

Raman

[ramandeep1980]

Just thought to bring this topic up.

As there has been not a very clear answer for this query around.

Though many has asked this question.

 

Raman

[cshaw]

Raman,

 

Did you get any information on this? I am trying to do the same, but not having success.

 

Chris

[slow]

try to read this and also the relative responses:

http://www.brianburridge.com/2006/06/04/how-to-call-stored-procedures-from-jasper-reports/comment-page-1/

 

 

______________________________
if it works... KARMA point please!    : ) 

[cshaw]

 I was able to call an Oracle Stored procedure by doing the following:

1) Set the Query language in the Report Query to plsql

2) Use the following syntax for the call "{call MyPackage.MyStoredProc($P{Cursor},$P{InputParam})}"

3) Define the Cursor param as java.sql.ResultSet

4) Type in the Fields of the result set by hand. I could not get the Automatically Retrieve Fields to work. 

I am using iReport 3.7.1 on Windows XP which is bundled with the jasperreports-extensions-3.5.3.jar that contains the necessary PlSqlQueryExecuter classes.

There was no need to follow the method described by Brian Burridge that made use of a temp table.

Chris

Post Edited by cshaw at 04/08/2010 17:39

[snemeth72]

Thanks cshaw! It was what we looking for!

Just for the complete solution. You can register the mentioned executer factory by:

net.sf.jasperreports.engine.util.JRProperties.setProperty("net.sf.jasperreports.query.executer.factory.plsql", "com.jaspersoft.jrx.query.PlSqlQueryExecuterFactory");

After registration you can use:

InputStream is = getClass().getClassLoader().getResourceAsStream("jrreports/CursorTest.jasper");
JasperPrint print = JasperFillManager.fillReport(is, new HashMap(), conn);

 

[pezajr]

Code:

Huraaaaa. I was searching for this for few hours. Indeed it works. Thank you.

 

Post Edited by pezajr at 10/14/2010 13:59

Code:

[code]Huraaaaa. I was searching for this for few hours. Indeed it works. Thank you cshaw.

 

Post Edited by pezajr at 10/14/2010 14:01

[eshwarkoti]

 Thanks alot....:)

After spending many hours i got this solution .....its working perfect for me.........

 

 

Thanks

Eshwar