How to Call stored procedure in SAIL form

sateeshn over 7 years ago

Hi,
Iam calling the procedure as below in sail form but not able to fetch the result and my procedure is returning cursor.
=with(
local!spResult: fn!executestoredprocedure(
"java:/jdbc/TIS_DB",
"SP_GET_DETAILS",
{
{name: "id", value: "%1%"}
}
),
if(local!spResult.success,
local!spResult.result,
local!spResult.error
)
)
Is it right way to call procedure in sail form

Discussion posts and replies are publicly visible

Parents

0 Stefan Helzle
A Score Level 3
over 7 years ago

I never tried to call stored procs in a SAIL interface. But within SAIL, functions that potentially modify data can only be used inside a saveInto statement. And this means only as the user interacts with the interface.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 7 years ago

I never tried to call stored procs in a SAIL interface. But within SAIL, functions that potentially modify data can only be used inside a saveInto statement. And this means only as the user interacts with the interface.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data