Jump to content
Changes to the Jaspersoft community edition download ×

How to call a stored procedure in iReports

Recommended Posts

By: Lalith - weeralalith

How to call a stored procedure in iReports

2006-03-15 23:42

Hi there,


Please help me on this.

I want to call an stored procedure in sidd the iReports Designer's "Report Quary".

Anybody pls tell me how to do this, specially the syntax with "exec" or "call"


Thanks in advance




By: Lalith - weeralalith

RE: How to call a stored procedure in iReport

2006-03-16 02:38

Hi folks,

I think i found the solution (half way). Following links will help you all i guess.







but still i'm wondering how to pass input parameters to the procedure.


is it like this


{call proc($P{param1}, $P{param2})}

this way is giving me problems like "PLS-00306: wrong number or types of arguments in call to 'proc'")


Can some body please tell me the correct way.




Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...