How to call a stored procedure in iReports

2006 IR Open Dicussion · August 27, 2006

By: Lalith - weeralalith

2006-03-15 23:42

Hi there,

Please help me on this.

I want to call an stored procedure in sidd the iReports Designer's "Report Quary".

Anybody pls tell me how to do this, specially the syntax with "exec" or "call"

Thanks in advance

Lalith

By: Lalith - weeralalith

RE: How to call a stored procedure in iReport

2006-03-16 02:38

Hi folks,

I think i found the solution (half way). Following links will help you all i guess.

but still i'm wondering how to pass input parameters to the procedure.

is it like this

{call proc($P{param1}, $P{param2})}

this way is giving me problems like "PLS-00306: wrong number or types of arguments in call to 'proc'")

Can some body please tell me the correct way.

Thanks,

Lalith

Recommended Posts