Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Newcomers » Newcomers » Linking data sets when one calls a stored procedure(Trouble using stored procedure result)
Linking data sets when one calls a stored procedure [message #841224] Wed, 11 April 2012 03:29 Go to next message
Paul Missing name is currently offline Paul Missing name
Messages: 3
Registered: December 2011
Junior Member
Hello,
I'm sure that this will be documented somewhere, but I've looked for ages and can't find it. (Yes, I'm very new to Birt. Sorry.)

I have an Oracle function that takes an input parameter. I've created the dataset to execute this function, and I can view the result when I write something like:

select MYSCHEMA.PRODUCTDETAIL(23) from dual

However, I want the function to be called for each product line in the PRODUCT table.

I can see how to merge normal data sets from the documentation. However, I simply cannot see how to call the result of a stored procedure from the dataset that I want to use to display it. I would be very grateful if someone could either write some points on how to do this, or point me to where it is documented? (from what I've read, I will probably need to change the 23 above to a ?, but I'm not sure what next.)

thank you.
Re: Linking data sets when one calls a stored procedure [message #841568 is a reply to message #841224] Wed, 11 April 2012 13:23 Go to previous message
Russell Bateman is currently offline Russell Bateman
Messages: 3189
Registered: July 2009
Location: Provo, Utah, USA
Senior Member

On 4/10/2012 9:29 PM, Paul Mising name wrote:
> Hello,
> I'm sure that this will be documented somewhere, but I've looked for
> ages and can't find it. (Yes, I'm very new to Birt. Sorry.)
>
> I have an Oracle function that takes an input parameter. I've created
> the dataset to execute this function, and I can view the result when I
> write something like:
>
> select MYSCHEMA.PRODUCTDETAIL(23) from dual
>
> However, I want the function to be called for each product line in the
> PRODUCT table.
>
> I can see how to merge normal data sets from the documentation. However,
> I simply cannot see how to call the result of a stored procedure from
> the dataset that I want to use to display it. I would be very grateful
> if someone could either write some points on how to do this, or point me
> to where it is documented? (from what I've read, I will probably need to
> change the 23 above to a ?, but I'm not sure what next.)
>
> thank you.

BIRT questions are handled in the Eclipse BIRT forum.
Previous Topic:python and pyglet on osx lion arch -i386
Next Topic:Eclipse IDE for EGL Web Developers
Goto Forum:
  


Current Time: Wed Sep 17 13:43:49 GMT 2014

Powered by FUDForum. Page generated in 0.02068 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software