How to call MSSQL stored procedure with input in IReport

[nithyanand11]

How to call MSSQL stored procedure with input in IReport.

Am using following query to call..

CALL MY_PROC($P{INPUT1}, $P{INPUT2}, $P{INPUT3});

but its returning this error

com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near '@P0'.

Please help...

 

Thanks in Advance

-Nithin

Post Edited by nithyanand11 at 01/05/2011 09:02

[siddarth.k]

Calling MSSQL stored procedure in IReport:

1)Select the language as plsql instead of sql in IReport

 

2)use the syntax mentioned below

MY_PROC $P{INPUT1}, $P{INPUT2}, $P{INPUT3};

 

Hope it will work for you.

-Siddharth