I'm trying to call my assemblys SP and receive the following error:
A .NET Framework error occurred during execution of user-defined routine or aggregate "Pmt_ImportJournal":
System.InvalidCastException: Specified cast is not valid.
System.InvalidCastException:
at JournalImport.Pmt_ImportJournal(Int32 orderno)
My SP in the assembly is defined like so:
[SqlProcedure(Name = "Pmt_ImportJournal")]
public static void Pmt_ImportJournal(int orderno)
Should I be using the SQL* datatypes instead of simply an int in the signature? For example SqlInt32?