Eclipse Community Forums: BIRT » can't get results of stored procedure for my dataset

Help

Home

Home » Archived » BIRT » can't get results of stored procedure for my dataset

Show: Today's Messages :: Show Polls :: Message Navigator

can't get results of stored procedure for my dataset [message #1106170]

Tue, 10 September 2013 19:58

Gibran Shah

Messages: 33
Registered: September 2013

Member

Hello,

I'm new here and new to both BIRT and Eclipse.

I have a stored procedure that looks like this:

create or replace
procedure GET_TAX_TYPE_BY_TAX_ENTITY_KEY (
TaxEntityKey in number,
results out SYS_REFCURSOR) as

begin

open results for
select *
from MyDB.TAX_SLIPS
where TAX_ENTITY_KEY = TaxEntityKey;

end

Now I want to use the results of this stored procedure to populate a report. So in creating my DataSet, I get to the point where I find my stored procedure in the Available Items window, but I'm not sure what to type for my query.

I tried the following:

variable results REFCURSOR;
{call MyDB.GET_TAX_TYPE_BY_TAX_ENTITY_KEY(123, results)}

(some of this data is faked for security reasons)

but I get an error saying:

"Cannot get the result set metadata.org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet Object.
SQL error #1:ORA-00900: invalid SQL statement..."

According to the error message, I'm not returning a ResultSet. But this is how everything on the net tells me to do it.

What am I doing wrong?

Report message to a moderator

Re: can't get results of stored procedure for my dataset [message #1106591 is a reply to message #1106170]

Wed, 11 September 2013 09:42

Rahul Kumar

Messages: 8
Registered: December 2012

Junior Member

Have you tried select query on your function name(GET_TAX_TYPE_BY_TAX_ENTITY_KEY).It should give you the result set if your function is returning the resultset correctly.

Report message to a moderator