Stored Procedure issue in K2 5.3 version

Hi Sunrise,
Thank you for the Quick reply.
I tried testing 2 of my Stored procedure using
SET FMTONLY ON;
SET FMTONLY OFF;
to check if the stored Procedure is returning schema. Both the Procedure is returning Schema. I have created SMO with return property using the same procedure in 5.2 version.

Kathija, K2 may not be able to understand that your stored procedure is returning an output. If your procedure code contains conditional logic (IF this then SELECT... ELSE SELECT...), it might be better to create a table variable, execute the conditional logic on the table variable, then select everything from the table variable at the end. Hope this helps!