Iam trying fetch data to be displayed in a grid from a table which is in externa

divyav over 8 years ago

Iam trying fetch data to be displayed in a grid from a table which is in external Database (not in Appian environment). We have data source name for it and stored procedure name but no other details. The current functionality is in Portal, where we are fetching data from that table through execute stored procedure smart service in a sub process. But now I need to implement it in 7.10 SAIL Interface. Within the same form I need to enter a firm name which will passed as input to that stored procedure and all details of that firm needs to be fetched from that and display in a grid.

Basically I need to know how to execute stored procedure in SAIL Interface.

Discussion posts and replies are publicly visible

Parents

0 divyav over 8 years ago

Thank you for providing the Plugin and function details

We have installed that jar file in our environment and I tried using the executestoredprocedurefunction in interface, but it is throwing error as "No procedure found with name: sp_Examples"

Code I have used for creating stored procedure is
CREATE OR REPLACE PROCEDURE sp_Examples(X IN OUT NUMBER) AS
T NUMBER;
BEGIN
T := X;

END sp_Examples;
/

DECLARE
A NUMBER:= 10;

BEGIN
sp_Examples(A);
DBMS_OUTPUT.PUT_LINE('A = ' || TO_CHAR(A));
END;

Code used for executestoredprocedure function is

with(
local!spResult:fn!executestoredprocedure("name of our data source",
"sp_Examples",
{{name:"X",value:1}}
),
if(local!spResult.success,local!spResult.result,local!spResult.error)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 divyav over 8 years ago

Thank you for providing the Plugin and function details

We have installed that jar file in our environment and I tried using the executestoredprocedurefunction in interface, but it is throwing error as "No procedure found with name: sp_Examples"

Code I have used for creating stored procedure is
CREATE OR REPLACE PROCEDURE sp_Examples(X IN OUT NUMBER) AS
T NUMBER;
BEGIN
T := X;

END sp_Examples;
/

DECLARE
A NUMBER:= 10;

BEGIN
sp_Examples(A);
DBMS_OUTPUT.PUT_LINE('A = ' || TO_CHAR(A));
END;

Code used for executestoredprocedure function is

with(
local!spResult:fn!executestoredprocedure("name of our data source",
"sp_Examples",
{{name:"X",value:1}}
),
if(local!spResult.success,local!spResult.result,local!spResult.error)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data