Stored Proc in Birt Report

Tripathi

Hello All,

I am using Birt Eclipse Designer for Birt Reporting and the backend is Oracle 9i.

I created a following package in oracle
=================================
create or replace package types
as
type cursorType is ref cursor;
end;
/
=================================
/*and a procedure */
=================================

create or replace procedure getemps( p_cursor in out types.cursorType )
as
begin
open p_cursor for select ename, empno from emp order by ename;
end;

=================================
the above package and procedure runs fine in oracle..even i am getting a result set ...

but when i try to use the same in Birt report designer it fails....
following is the way i am using procedure in eclipse birt

1.I create a new report
2. establish a DataSource Connection
3. Create new Data Set
4. and i call my procedure in following way in Query tab

call SCOTT.GETEMPS(' ')

but it throws an error msg
"can not get the resultset meta data
SQL statement does not return a resultset object"

does anyone have any clue why is it not working in Birt environment.

Thanks in advance

bhanley

Two things to check:<br />
<br />
1) Make sure you are using a "Stored Procedure" data set. When you create the Data Set, the second drop-down allows you to specify a type of "Stored Procedure".<br />
<br />
2) Make sure you wrap your call in curly braces. Like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>{call SCOTT.GETEMPS(' ')}</pre>
<br />
Good Luck!