Jump to content
Changes to the Jaspersoft community edition download ×

Calling Oracle Stored Procs/Functions


2005 IR Help

Recommended Posts

By: Nancy - deann

Calling Oracle Stored Procs/Functions

2004-03-04 16:01

We have a requirement to use either stored procedures/functions to source the data for our reports but I'm confused as to how the data is returned to Jasper. I've seen other threads which say that in a stored procedure a resultset will be returned but how? If you do a SELECT statement in a procedure with INTO variables/records then how is this data returned to Jasper? Or can we use an Oracle user-defined function and, if so how is this called?

 

 

 

 

By: rakhesh - rakheshg

RE: Calling Oracle Stored Procs/Functions

2004-03-17 01:19

Hi,

 

In ur xml, the SELECT statement as well as the StoredProcedure can be used in the similar way. The SELECT statement /stored procedure call should be given in the <queryString> tag. And specify the fieldnames similar to the one you used to select the values from database tables. Jasper will take care of assigning the fields while filling the report.

 

 

 

 

By: ani - vijani

RE: Calling Oracle Stored Procs/Functions

2004-09-20 20:39

Can you please provide me an example of calling a stored procedure in oracle.

 

Thanks

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