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

rpolunsky

I have a report somewhere that will do this. I'll look for it.