call the procedure of SQLSERVER to get the resultset,an error Parameter @pname was not defined for stored procedure occurs.

0
I want to call the procedure of SQLSERVER to get the resultset, I used the Execute parameterize query of the database connector.When I run microflow, an error occurs.   procedure     com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Parameter @pname was not defined for stored procedure proc_selectProject.     at AwsTestModule.Microflow_Sql_Procedure_Get_SelectList (JavaAction : 'Execute callable statement') Advanced stacktrace:     at com.mendix.modules.microflowengine.MicroflowUtil.processException(MicroflowUtil.java:83) Caused by: com.mendix.core.CoreRuntimeException: com.mendix.systemwideinterfaces.MendixRuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: Parameter @pname was not defined for stored procedure proc_selectProject.     at com.mendix.basis.actionmanagement.ActionManager.executeSync(ActionManager.scala:84)    
asked
1 answers
0

Hi , 

Try to Use Parameterized Statement for the same not Query . Query its refers to Select Query not the Procedures

answered