Errors with cursor parameter in oracle stored proc populated Dataset

Hi,

I am having problems getting a stored procedure to work as the dataset populator in the designer tool. I am using :

Eclipse IDE for Java and Report Developers
Build id: 20100218-1602

and oracle JDBC driver version ojdbc-11.1.0.6.jar

I have followed a number of threads and instructions on the web on calling a stored procedure under oracle in BIRT. The issue I am seeing is that the stored procedure is not returning any data to my report. I am certain that the proc returns data as I can run it in a java based unit test.

The database is oracle, so the stored proc has an out paramter that is a ref cursor in order to pass data back as a result set.

Below is the configuration information in the DataSet properties window of the builder

Query Tab
has : { call WBC.HQP_WEB_GXFEES.GET_GX_FEES(?,?) }

Output Columns Tab
Contains all the columns return by the stored proc cursor.

Paramters Tab
Has 2 parameters :
The input parameter (of type string with a default value)
The output parameter - blank type, named P_CURSOR)

Settings Tab
Has Fetch all rows from datsource checked.
Enable resultset selection is NOT checked - although I have tried to set this and name the out parameter explicitely but it does not seem to make any difference.

The Preview Out Parameters Tab
Is empty. It has a heading of P_CURSOR (the out parameter name) for the first column.

The Preview Results Tab seems to connect to the dbase but comes back with column headings but no data.

A few questions :

1) Is there a way to debug the database query mechanism to verify the query parameter is being passed correctly?

2) Can anyone suggest what steps to take to further debug the issue?

thanks,

Michael

Find more posts tagged with

Comments

Virgil Dodson

I am moving this thread to the BIRT Designer forum so other there may have an answer.

msos

Still waiting for any suggestion on this? Is there no one in the BIRT community that can suggest how to debug such issues?

Michael