Skip to main content
erikajaze418862
December 4, 2023
Question

Execute Store Procedure for Query, Null Output

  • December 4, 2023
  • 1 reply
  • 0 views

Hi, I have a rule in which I call an SP.
I made changes to a field so that it accepts an array and now my Rule is not working. 


I'm not getting an error, just nulls. Any idea?


with(

local!result: a!executeStoredProcedureForQuery(
dataSource: cons!SOP_ARC_CONS_ALMACEN_DATOS,
procedureName:"SOP_ARC_GETTOTAL_INFORMESLAS",
inputs:{
a!storedProcedureInput(
name: "STARTINDEX",
value: if(
isnull(
ri!startIndex
),
0,
ri!startIndex - 1
)
),
a!storedProcedureInput(
name: "BATCHSIZE",
value: if(
isnull(
ri!batchSize
),
100,
ri!batchSize
)
),
a!storedProcedureInput(
name: "SORTBY",
value: if(
isnull(
ri!sortBy
),
"idinstancia",
lower(ri!sortBy.field)
)
),
a!storedProcedureInput(
name: "ASCENDING",
value: if(
isnull(
ri!sortBy
),
true,
tointeger(ri!sortBy.ascending)
)
),
a!storedProcedureInput(
name: "RESULTADOSMAXIMOS",
value: cons!SOP_ARC_INFORMES_MAX_RESULTADO_PANTALLA_ONLINE[ri!codigoInforme]
),
a!storedProcedureInput(
name: "TIPOPROCESO",
value: "'"&joinarray(ri!procesoS,"','")&"'"
),
}

1 reply

stefanhelzle0001
December 4, 2023

It is almost impossible to support you without knowing any details about that stored procedure. If there is no error, the problem might be bad parameters, or the procedure itself.