stored procedure out values to reports

Hello,
I have seen some threads with similar questions, but I don't think that I saw a clear resolution. I have just started to use BIRT and was able to look at online tutorials to map simple sql queries to the report.

My issues is that I have stored procedures to run on oracle that have some out values. In the dataset, I created an SQL dataset and was able to put my query in
{call DEV.CUST_FIND(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)} ,

After I do that I get a populated data set but they cannot be dragged onto the report. What do I need to do to get this to work. I've read something about parameter mapping, but it seemed that only input parameters work. If I put a parementer in, it asks me for a value and then puts the value that I entered on the report. I want to see the OUT values and show them on the report.

I am using ORACLE as my database and the ojdbc14.jar for the driver.

Thanks in advance

Find more posts tagged with

Comments

bhanley

How are you mapping values in for all those parameters ("?") in your stored proc call? You need to bind a value to each question mark in the string. If not an input parameter, what is it?

pshah

Thanks for you reply. One of the parameters is defined as an IN value the rest are called IN/OUT values. When I click on the preview OUTPUT parameters (after I define a dafault IN value) , I can see my output values however I cannot drag and those from the Dataset onto my report. How do I get those to show up on my report?

The values on the dataset viewer look like {} value_x. Do I have to do some kind of mapping so that I can drag them onto the report layout?

Thanks

pshah

_florian_

Hi,

I'm facing exactly the same problem.
Is there any solution?

Thanks!
Florian

Ronak

Hiii,

Its that the same problem I have. NOt able to find any solution. Is any answer or solution available to anyone. Please respond.

Hans_vd

Hi,

The only way that I could think of to make it possible to get non cursor output values on the report, is to bind them to a report parameter. When I do this, I get the message "Are you sure you want to update the report parameter's value with the dataset parameter's value?". Well that's exactly how I was hoping it would work, but it doesn't seem to work. The right value isn't passed to the report parameter.

Ronak

<blockquote class='ipsBlockquote' data-author="'Hans_vd'" data-cid="79556" data-time="1309812264" data-date="04 July 2011 - 01:44 PM">
Hi, 
 
The only way that I could think of to make it possible to get non cursor output values on the report, is to bind them to a report parameter. When I do this, I get the message "Are you sure you want to update the report parameter's value with the dataset parameter's value?". Well that's exactly how I was hoping it would work, but it doesn't seem to work. The right value isn't passed to the report parameter. </blockquote>
 
Can you provide any example of it...please. 
Thnnks

Hans_vd

That would be useless, as it is not working, isn't it?