Oracle Stored Procedure RefCursor Output

Padmanaban

Hi All,

I am new to BIRT. I am trying to invoke a Oracle SP which has 2 input parameters and an output RefCursor.

Query : {call pkg.sp_name(?,?,?)}

After entering the default Values for the input parameters in the Parameters section, when I click the preview results, I get the following error:

A BIRT exception occurred.
Plug-in Provider:Eclipse.org
Plug-in Name:BIRT Data Engine
Plug-in ID:org.eclipse.birt.data
Version:2.2.2.r22x_v20071212
Error Code:odaconsumer.CannotFetchNextRow
Error Message:Cannot fetch the next data row.
Cannot move down to next row in the result set.
SQL error #1: ORA-01002: fetch out of sequence

QUESTION:
Does this version of BIRT (Version:2.2.2.r22x_v20071212) support oracle ref cursors?
If YES, what am I missing?

I use the ojdbc14.jar driver.

Any help would be very much appreciated.

regards
paddy

Padmanaban

Report is working with RefCursor output when
1) no input parameters are present in the SP
2) an Integer input is present in the SP.

It does not work (throws the above mentioned exception) when the varchar2 input is used. Weird !
I am passing a date value like ('01/01/2002') and use this in the procedure like to_date(dt, 'mm/dd/yyyy')

Is the driver that I use, not supporting certain operations?

Any thoughts on this.

Thanks
Paddy