Unanswered

Flow Execute Procedure Invalid data type for parameter 'Column Name' found. (Numeric(8,2) Type/format

(0) Share

Report

Posted on by sspencer

Can anyone tell me why I receive the "Invalid data type for parameter" error when I try to execute the procedure in flow? The procedure runs fine in SSMS with no errors. When I remove the two numeric data types the errors do not show up in flow. I can't figure out what I may be doing wrong. According to the documentation it seems to me the numeric data type is valid.

Categories:

Using flows

I have the same question (0)

All responses (2)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @sspencer ,

From the screenshots you provided, it seems that the field types defined in the procedure are all correct.

Flow related documentation also states that numeric fields are supported data types.

Please consider recreating a similar procedure, and then use the new procedure to configure the action to see if similar errors persist.

Best Regards,

Was this reply helpful? Yes No
sspencer 6 on at

Like (0)

Report

Thank you for the reply. I tried recreating the procedure in a simpler version. It executes just fine in SQL but errors out when it is added to the SQL Execute Procedure flow. When I remove the parameters that contain the numeric value types it works fine.

Was this reply helpful? Yes No