Error While inserting data in stored procedure

Hello,

Please try to use Execute Query instead of Execute Non Query.

Please find below article:

Thanks