April 25, 2011 at 11:28 am
i wrote a Sp where there are 2 output parameters @a(nvarchar), @b-2 (int).
Having errors related to the second parameter. Mapped this parameters in Execute storeproc as follows:
a output (datatype) Nvarchar 0
b output numeric 1
Tried changing @b-2 datatype to Long, but i couldn't figure it out.
Error:
The type of the value being assigned to variable "User::b" differs from the current variable type. Variables may not change type during execution. Variable types are strict, except for variables of type Object.
but donot know, what excatly its telling me.
Incase this may help you to figure out, i am creating variables (package scoped ) same as the Storeproc variables (i.e a(Datatype string) , b(datatype int)
April 26, 2011 at 8:24 am
Not sure if you tried this yet, but in your procedure, try using BIGINT instead of int.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply