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; } } }

call stored procedure from birt report

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

Find more posts tagged with

Comments

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