Hi,
I am using the RDC to connect to MS SQL Server 2008, I have created a stored procedure with an input value and an output value.
Procedure is detailed below:-
ALTER PROCEDURE dbo.sp_Increment_CustomSerialNumber (
@OwnerCode varchar(10),
@Number int OUTPUT
)
as
BEGIN
--insert procedure body here
set @Number = (SELECT Serial from TblCustomerCustomSerialNumbers WHERE OwnerCode = @OwnerCode)
--inc the value
set @Number +=1
Update TblCustomerCustomSerialNumbers SET Serial = @Number WHERE OwnerCode = @OwnerCode
END
The corresponding entry in the commands section of the config file is below:-
sql.kitting_getCustomDigits=DECLARE @return_value int,@Number int ;EXEC @return_value = sp_Increment_CustomSerialNumber @OwnerCode = N?,@Number = @Number OUTPUT; SELECT @Number as N'Number'
The stored procedure runs fine when executed in sql server manager
DECLARE @return_value int,@Number int ;EXEC @return_value = sp_Increment_CustomSerialNumber @OwnerCode = N'ABB',@Number = @Number OUTPUT; SELECT @Number as N'Number'
but i get the following error message in the B4a log when executing
java.sql.SQLException: Incorrect syntax near '@P0'.
Any ideas on what is going on?
Regards