Jump to content
Changes to the Jaspersoft community edition download ×

Need to execute oracle stored procedures


Recommended Posts

  • 2 weeks later...
  • Replies 3
  • Created
  • Last Reply

Top Posters In This Topic



There is nothing special you need to do to use a stored procedure call in the <queryString> tag of JRXML as long as that stored procedure does not have OUT parameters and returns a ResultSet.

This means that the stored procedure can be executed through a PreparedStatement in JDBC.

If your stored procedure does not comply with these, then it must be called through CallableStatement in JDBC and JasperReports does not know how to handle this by default. And you probably need to call that stored procedure in you application and pass the data as a JRDataSource to the engine.


I hope this helps.


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...