BIRT 2.6.1 Report Designer and Oracle 10g/11 SQL Issue

See more:

SQL

Eclipse

Two questions:
1) Has any BIRT report designer user had to tweak his/her stored SQL stored procedure code to get BIRT report designer and the store procedure to work together;

2) Has any BIRT user had a problem where BIRT report designer cannot complete a successful stored procedure call, even though the the stored procedure is correctly defined and the relationship (same number and type of parameters in SQL code and BIRT report designer, procedure definition call in BIRT report designer, et cetera) between the stored procedure and BIRT report designer is properly set up?

Am using BIRT 2.6.1 report designer to create reports that pull data from Oracle 10g via stored procedure calls. All of these stored procedures return cursors.

The problem that I am having is that I have to tweak my stored procedure SQL code to get the BIRT report designer to work with the stored procedure. Some of the BIRT reports work with my stored procedures; others do not. The tests that I perform via SQL Navigator / SQL Developer run without a hitch. In addition, there is nothing wrong with my BIRT report implementation: 1) the number of parameters are properly defined on both sides of the equation (stored procedure definition and BIRT report designer); 2) the parameter types are correctly defined in the stored procedure definition and the BIRT report designer definition; and 3) the procedure call in BIRT report designer is set-up correctly.

Has anyone come across anything like this? If so, what did you do?

If you are able to understand where I am going with this, great. The problem is, though, I cannot provide any code examples or returned error messages due to security restrictions here. Otherwise, I'm out of luck here.

I would greatly appreciate any help here.

Thank you very much!

Matthew.