Hi all, I have the following question, Im using a stored procedure using

$queryRaw

, my stored procedure returns two results, but I am only getting the last one. Is there any way to get both values?

Hi Ignacio 👋 If you directly execute the stored procedure on your database without using Prisma does it return both values? Which version of Prisma are you using?

Hi Nurul, thanks for the answer! Yes if I execute it with datagrip I get two values, the version im using of prisma is

3.14.0

, does the new version allow this feature?

We did make some improvements in

$queryRaw

method in version 3.14.0. You would need to enable

improvedQueryRaw

preview feature to test it. I would suggest to check this with improvedQueryRaw enabled.

Thanks, I already give it a try but no luck on getting both tables as results

Oh I see, could you create a Bug Report for this so that our engineering team could have a look?

👋 Hello @Ignacio Velasco, did you have a chance to check Nurul's suggestion? Let us know if you were able to create the bug report!

Thanks for the follow up, we decide to return everything in JSON, in order to achieve deadlines. Next week I’ll write a detail bug report!

Thank you for following up - I completely understand the importance of having a stable solution when deadlines are involved! If you ever want to revisit this, please let us know and we'll review this bug asap!