Hi I use extension by reference to OutSystems.RuntimePublic.Db library. This is my code:
using (Command cmd = trans.CreateCommand())
{
.....
//add return value
var resultvalue = cmd.CreateParameter("value1");
resultvalue.GetDriverParameter().Direction = ParameterDirection.ReturnValue;
resultvalue.DbType = DbType.String;
....}
cmd.CreateParameter(string name) must have a parameter name. I use fake parameter "value1" in the constructor but it doesn't work.
Does anyone have idea how to write return value code here?
Hi Larry,
Check this link link for stored procedure usage
https://success.outsystems.com/documentation/11/reference/outsystems_apis/runtimepublic.db_api/call_a_stored_procedure/
Hope that it helps you
this document only gave input and output type, not clear for ReturnValue direction.