I have a stored procedure I’m trying to get working in FactorySQL and I keep getting the same error. “…Procedure ‘SP_LRunNumbers’ expects parameter ‘@inputRunNumber’, which is not supplied.” My stored procedure is set to return one string.
I can call the procedure from Access using a pass-through query on this same machine, using the same DSN connection. So it shouldn’t be a permissions issue.
I’ve got two OPC items in the group; one acting as the input for the stored procedure named CurrentRunNumber, the second should be the return value of the SP, named WriteBackNumber.
If I look at the item configuration for CurrentRunNumber, I checked “Map to in param: InputRunNumber”. InputRunNumber is the input parameter in my stored procedure. I even changed the name of the input parameter on the SQL server and when I clicked the down arrow here, the name of the “in param” changed to the new name. So I know it SEES my stored procedure. I checked “Don’t write back to OPC”. As far as I can tell, by reading through the help file, this SHOULD send the current value of this tag to the stored procedure, but FSQL is acting as though I haven’t even set this up.
On the item configuration for WriteBackNumber, I checked “Map to return value”. But I haven’t gotten far enough to see if the SP will return its value to this tag.