How To Get Stored Procedure Output?
and a Business Operation calling the SP
The following code executes the stored procedure successfully , but does not return the output.
what needs to be fixed?
set outparm = ""
set pResponse = ##class(Ens.StringResponse).%New()
SET SQLQuery2 = "{call s_sproc (?,?)}"
SET tSC = ..Adapter.ExecuteProcedure(,,SQLQuery2,"io*",pRequest.StringValue,outparm )
set pResponse.StringValue = outparm
Thanks