nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

can't use results of stored procedure when setting up dataset

gib65

Hello,I'm new here and new to both BIRT and Eclipse.I'm trying to use the results of a stored procedure in a report. I'm trying to follow along with this guide:<a data-ipb='nomediaparse' href='http://enterprisesmartapps.wordpress.com/2011/02/24/oracle-stored-procedure-data-set-in-birt/'>http://enterprisesmartapps.wordpress.com/2011/02/24/oracle-stored-procedure-data-set-in-birt/</a>Here's the stored procedure: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 FBC_DBA.TAX_SLIPS
where TAX_ENTITY_KEY = TaxEntityKey;

end;I'm trying to create a DataSet in Eclipse. I set the type to SQL Stored Procedure Query. Then I located my stored procedure in the available items list. So my query looks like this:

Find more posts tagged with

Comments

Hans_vd

Hi, You literally took over the parameter value from the blogpost :-) Your procedure call statement should look like this:[color=rgb(0,0,0);font-family:helvetica, arial, sans-serif;]{call FBC_DBA.GET_TAX_TYPE_BY_TAX_ENTITY_KEY (?, ?)}[/color] Succes!

gib65

Thanks Hans, that worked. Yeah, I know it seems strange to use exactly the same values as in the example, but at the time, I had tried everything else. Besides, in the example, the term 'TABLE' wasn't used anywhere else, so I thought *maybe* it was a special string that had to be passed in (as in, the data type for the output should be a table). Thanks again.

Hans_vd

Nice to see you worked it out!I realize now that 'TABLE' looks very much like a keyword and could be confusing.