Forum Discussion

anand1's avatar
anand1
Contributor
4 years ago

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

JDBC
JDBC< sql
sql
stored proc
temp tables

3 Replies

Sort By
  • richie's avatar
    richie
    Community Hero
    4 years ago
    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
    • sonya_m's avatar
      sonya_m
      SmartBear Alumni (Retired)
      4 years ago

      Thanks Richie!

       

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