Pass BigInt as parameter to ExecuteNonQuery Activity

Help Activities
, ,
1

Hello Team,

I have a SP with a parameter as BigInt Datatype. I am trying to pass the value as “BigInteger.Parse(StringValue)” and end up with error as “Execute Non Query: No mapping exists from object type System.Numerics.BigInteger to a known managed provider native type”. Can anyone help me to resolve this error?

Thanks

1 Like
2

Hi @Janet_Caroline

Try passing int64 type please.

Thanks
#nK

3

I tried using Int64 and got “Execute Non Query: Error converting data type varchar to bigint.” error

1 Like
4

Could you please let me know what are all the types you tried pls ?

5

we would suggest following:

  • Share with us which DBMS is in use
  • which datatype is configured within the data table schema for this column
1 Like