[Aarika S S]

Hi,

When I call a stored procedure from my birt report like ,
{call get_data_rpt(?,?,?,?)} and click anywhere ,it shows error

"org.eclipse.birt.report.data.oda.jdbc.JDBCException: Cannot get result set metadata.
SQL error #1:ORA-00900: invalid SQL statement"

please help me to solve this issue.What are the steps required to call a stored procedure within birt.

Thanks & Regards
Aarika

[JasonW]

Did you set default values for the data set parameters?

Jason

[Aarika S S]

Yes..
I set default values and gave binding.but now i got error like,
"org.eclipse.birt.report.engine.api.EngineException: Cannot get the result set metadata.
Cannot get result set metadata.
SQL error #1: ORA-00900: invalid SQL statement"

Regards,
Aarika

[JasonW]

Can you try hard coding the parameters as a test?
{call get_data_rpt(1,2,3,4)}

Jason

[sunnypatel285]

First you call stored procedure in sql editor,by giving definite parameter.

[bgbaird]

You might want to try this, It will give you a lot of flexibility while you are developing:

declare @var1 <TYPE>
declare @var2 <TYPE>
declare @var3 <TYPE>
declare @var4 <TYPE>

set @var1=?,@var2=?,@var3=?,@var4=?

{call get_data_rpt(@var1,@var2,@var3,@var4)}

Brian

[bgbaird]

Double Post, sorry