Invalid Parameter on Stored Procedure

Question

I am getting an error "???errors.invalidParameters???" when attempting to execute a SQL Function. 
 
 Here is my sQL select statement for my function: 
 SELECT * FROM [dbo].[p3_labor] ( <@inv_mast_uid, int,>) GO 
 a!executeStoredProcedureForQuery(
 dataSource: cons!POO_P21_Connection,
 procedureName: "p3_labor",
 inputs: a!storedProcedureInput(
 name: "inv_mast_uid",
 value: 114530
 )
)

Mike Schmitt · Accepted Answer

I'm not sure a!executeStoredProcedureForQuery() can access functions. It would be neat if it could, though. 
 In case this makes any difference: if the procedure's input variable is "inv_mast_uid", then from what i've seen, it should be referenced inside the procedure without the "@" character. Though I should disclaimer that I'm not thoroughly versed in all styles of syntax that can be used in procedures, so I could be assuming incorrectly here.

Invalid Parameter on Stored Procedure

Top Replies