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.
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
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.