Jump to content
Changes to the Jaspersoft community edition download ×

Oracle Stored Procedure Example?


2005 IR Help

Recommended Posts

By: dahlw656 - dahlw656

Oracle Stored Procedure Example?

2004-11-24 10:45

I'm trying to use Ireports/Jasper to query an Oracle stored procedure with 3 vars in and a reference cursor out. I can't quite figure out how I should format the querystring. I thought it would be something like:

 

exec mypackage.myprocedure('var1','var2',var3')

 

but doesn't seem to work and not sure how I would tell it what the ref cursor out would be. In java, I've been able to use callable statement.. but can't see how to do that here.

 

Has anyone successfully done this using Jasper? Can you provide an example of what the querystring would look like? Thanks for any help you can provide, this is a deciding factor on whether I can convince my agency to use Jasper.

 

 

 

 

By: Nikola Lazarevic - nikolal

RE: Oracle Stored Procedure Example?

2004-11-27 11:32

Try with {call mypackage.myprocedure('var1','var2',var3')}

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