How to call stored procedure with parameter from OpenRPA

[PRAMODH_RAMANAYAKA]

Hi Allen,

As shown in above diagram I am trying to execute stores procedure in my Postgres DB.
I change the command Type to stores procedure.
So how can I configure procedure name.
Also I want to pass two parameters to store procedure.
Could you please advice me how could I achieve this.
Thank you.

Regards,
Pramodh

[Allan_Zimmermann]

Normally, when you call a stored procedures using ADO, you set command text to the stored procedure’s name and then map each parameter seperately …as you can see, the activity is missing a way to map those parameters. I had planned to add those using the normal variable mapping UI ( as on “invoke OpenRPA” and latest version of “Invoke code” ) but i never got around to implementing that last bit

With MSSQL we can still call stored procedure and function, by using CommandType text

With functions you can query them as a table, for instance
select * from [dbo].[MyFuncton]('something', 42)
With Stored Procedures using EXEC command, for instance
exec [dbo].[MyProcedure]('something', 42)

I think you can do the same with postgree, just replacing exec with CALL

Note: you must use the correct activity depending on the return type.
If the stored procedure is returning a single value, use “ExecuteScalar” if the stored procedure is not returning anything use “Execute Non Query” and if the stored procedure is returning a table use Execute Query

[PRAMODH_RAMANAYAKA]

Hi Allen,

Thank you very much.

Regards,
Pramodh