SQL Issue executing Store Procedure with parameter varchar(8000) in Microsoft Flow

(0) Share

Report

Posted on by Ankita2020

Hi,

I have a store Procedure below which contains input parameter @customer_Test with varchar(8000).

ALTER PROCEDURE [dbo].[SPTestCustomer]
(
@company_id VARCHAR(8)
,@inv_mast_uid VARCHAR(2000)
,@prod_group_id VARCHAR(8) = NULL
,@customer_Test VARCHAR(8000)
)
AS
SET NOCOUNT ON
Select
count(@@ROWCOUNT) NumberofRows

FROM dbo.TableEmp

return

Now I successfully connected my database using On-Premise Gateway connector. And I am trying to execute my store Procedure through SQL Server "Execute stored procedure (V2)" action as shown below:

But my flow is failing and giving me error "The size (8000) given to the parameter '@Variable3' exceeds the maximum allowed (4000)."

This works well when I remove the input parameter with varchar(8000). Is there any limitation in MS Flow???

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (0)

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report

Hi @Ankita2020

You may check the current limitations with the SQL connector here: https://docs.microsoft.com/en-us/connectors/sql/

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Ankita2020 6 on at

Like (0)

Report

I could not see any variable limitation in the link. Please let me know if I am missing anything??

Was this reply helpful? Yes No
Ankita2020 6 on at

Like (0)

Report

Any Idea about varchar(8000) variable limitation while executing Store Procedure through MS Flow? FYI, we cannot edit the Store Procedure.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Ankita2020 Did you find a solution for this? im having the exact same.

Was this reply helpful? Yes No
bk2020 6 on at

Like (0)

Report

I am experiencing the same issue.

Has anyone found a resolution to this issue?

Thank you.

Was this reply helpful? Yes No
bk2020 6 on at

Like (0)

Report

I am experiencing the same issue.

Has anyone found a resolution to this issue?

Thank you.

Was this reply helpful? Yes No
MattinWi 2 on at

Like (0)

Report

Sorry to hijack after so long, but I am in this same situation and am not finding anything anywhere else about this.

Was this reply helpful? Yes No