• State Suggested Answer
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 10 subscribers
  • Views 9059 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Facing issue with executestoreprocedure()

Vinod Tate
A Score Level 2

HI All,

I am calling store proc which is having one input and output parameter. When i giving call to SP it is returning null even though there is record for input.

local!result: fn!executestoredprocedure(
dataSourceName:"jdbc/#####DS",
procedureName: "###APPIAN.TEMP",
inputs:
{
{name: "caseId", value: ri!caseId}

}
),

if(local!result.success,
local!result.result,
local!result.error
)

Any prompt help will highly appreciated.

Thanks,

  Discussion posts and replies are publicly visible

Parents
  • 0
    In the stored procedure If you're writing to an OUT parameter, instead update so it is an INOUT parameter

    after executing, the parameter can be accessed like: local!result.parameters.inoutparametername

    if the stored procedure executes a query, those results will be returned in the 'result' field: local!result.result

    there are also some issues where numbers need to be cast as a char in the stored procedure to be returned correctly
Reply
  • 0
    In the stored procedure If you're writing to an OUT parameter, instead update so it is an INOUT parameter

    after executing, the parameter can be accessed like: local!result.parameters.inoutparametername

    if the stored procedure executes a query, those results will be returned in the 'result' field: local!result.result

    there are also some issues where numbers need to be cast as a char in the stored procedure to be returned correctly
Children
No Data

© 2024 Appian. All rights reserved.