Execute query with parameters is not working as expected

[Karun (Karun Kumar Nalam)]

Hi All,

I am trying to call one procedure from my project but I’m facing below issue

But I’m passing the reqNo in parameters property of execute query activity

and this is the proc I’m calling

I’m not understanding where I’m going wrong can anyone help me pls…

[Palaniyappan (Palaniyappan P)]

Hi @Karun
remove the @ in variable name @reqNo and keep as reqNo
and try to execute with the same query… @Karun
or still not working, kindly have a look at this thread

How to Pass variable to sql execute query?

Ok, delete dlg from parameters and paste into query this: “Select * into " + dlg.ToString + " from Sheet1$ where 1=1” Set dlg value type as GenericValue.

Passing variable to SQL query

Hello guys, I was trying to pass variable (by parameter option) to my SQL query. Blockquote “Select START_DATE, NRB FROM blabla.blablaT_V Where START_DATE between” + date1 + “And ‘07/21/2018’” Blockquote Date1 is a variable passed to SQL query But still get error. I can only pass query with variable as whole as variable (so lets say date2 = “Select START_DATE, NRB FROM blabla.blablaT_V Where START_DATE between ‘07/01/2018’ And ‘07/21/2018’” How can I pass variable to query withou…

Cheers @Karun

[Karun (Karun Kumar Nalam)]

Thanks @Palaniyappan for your quick reply

I tried removing @ in @reqNo but still no luck

[Karun (Karun Kumar Nalam)]

From the above thread, he is saying to write entire query with parameters

then what is the use of Parameters property of Execute Query activity and I have total 10 to 11 parameters to pass, how complex the string will be

Is that the only way to pass parameters to proc?

[pllo2ptk (Swoodie)]

Nobody said that Will be a easy query

[Karun (Karun Kumar Nalam)]

Yes @pllo2ptk, Its not a easy query but sending parameters through Parameters property will be the best way for this kind of scenarios I mean when we need to send more parameters

[Sebastian_90]

Hello @Karun, I got the same problem and I resolved it by changing the CommandType from text to stored procedure in the Execute Query properties panel

[sourupnag]

This helped me. Thanks