meanings of error messages

[rrajarat]

I get the following error message when I try to execute a stored procedure. What doe it mean. The message comes up at the very beginning where the parameters are being recieved.

[Microsoft][ODBC SQL Server Driver]Invalid character value for cast specification

 

[cdukes]

It looks like you are tring to send the wrong kind of data to the Stored procedure, Check all your input variables

eg.
sp_check '1', '23-23-2002',1

sp_check @val1 as interger, @val2 as datetime, @val3 as varchar(1)

All these values will fail as they cannot be converted to the correct types.

The correct syntax should be

sp_check 1, '23-09-2002,'1'

Hope this helps,

Chris Dukes