Skip to Content
0
Jun 24, 2014 at 09:55 AM

error when call sql server stored procedure

44 Views

hello everybody,

I'm working with MII 14 and I want call a SqlServer stored procedure provided from my customer.

I configured a FixedQuery like this:

[dbo].[spElencoEntrateUscite_AV] @delta = 0, @daquando='130101', @CompanyID='000002', @Elenco = @MyCursor OUTPUT

but when i test the query i have back the error:

com.microsoft.sqlserver.jdbc.SQLServerException: Must declare the scalar variable "@MyCursor".

I tried also to set the query like this:

[dbo].[spElencoEntrateUscite_AV]

and pass Parameters:

0

130101

000002

OUTPUT

but i have this error:

com.microsoft.sqlserver.jdbc.SQLServerException: Procedure or function 'spElencoEntrateUscite_AV' expects parameter '@Elenco', which was not supplied.

Any suggestion?

thanks in advance

Alex