Ask a Question

Dynamic query, temp table, insert select

anand1
Contributor

Dynamic query, temp table, insert select

Hi, 

 

I went thru this older post

https://community.smartbear.com/t5/SoapUI-Pro/Stored-Proc-DYNAMIC-SQL-returns-no-rows/td-p/42621

 

And i also have the similar problem, I am creating a temp table, inserting the data using a SP and then doing some select based on my criteria

I am using JDBC test step in my test case to execute this, whenever I am executing it, I am not getting any error, instead i m getting 

<Results>
<UpdateCount>0</UpdateCount>
</Results>

 

Although, I expect the output of my Select query which is my last statement.

I can see it use to be a bug in earlier version.

Not sure if that is still an issue, or am I missing something.

 

Thanks in advance.

P.S: It is working fine if I am executing the same in SSMS(Sql Server Management Studio)

 

Regards,

Andy

3 REPLIES 3
richie
Community Hero

Re: Dynamic query, temp table, insert select

Hey @anand1,

I dunno if i can help, but i'll try and reproduce the issue on my readyapi!/sqlserver instance.

Im using readyapi! v3.3.0, what version are you using? Im gonna assume its not a driver problem cos you say it works using groovy, but not the embedded functionality, right?

Can you attach the storedproc so i get a feel for what its doing? I'll try and build an sp on my instance replicating the basics of your sp.

Nice one,

Rich
if this helped answer the post, could you please mark it as 'solved'? Also if you consider whether the title of your post is relevant? Perhaps if the post is solved, it might make sense to update the Subject header field of the post to something more descriptive? This will help people when searching for problems. Ta
sonya_m
Community Manager

Re: Dynamic query, temp table, insert select

Thanks Richie!

 

Hi @anand1 ! The Community will be happy to help you, but we need some more info (refer to Richie's reply).


Sonya Mihaljova
Community and Education Specialist

Did my reply answer your question? Give Kudos or Accept it as a Solution to help others. ⬇️⬇️⬇️
anand1
Contributor

Re: Dynamic query, temp table, insert select

Thanks @richie 

 

Please find one of the Proc below

https://pastebin.com/394tJwCW

 

Let me know if you need any other information, apology for late response.

 

Thanks,

andy

cancel
Showing results for 
Search instead for 
Did you mean: