| Linking data sets when one calls a stored procedure [message #841224] |
Wed, 11 April 2012 03:29  |
 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  |
|
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.
|
|
|
Powered by
FUDForum. Page generated in 0.07966 seconds
] 
Search
Help
Register
Login
Home
