How to execute stored procedure in uipath?

Help
,
21

EXEC package.procedure(var1, var2);

22

Hi,

I am dealing with a problem and need help.

I have a stored procedure with parameters which makes

  1. insert into select between begin and end
  2. delete between begin and end
  3. delete between begin and end (from different table)

And it works manuelly.

However when i called the sp by ‘execute non query’ activity,

  1. insert does not work
  2. delete works and deltes records
  3. delete does not work.

All the statements uses the same parameters. So prameters are right.

Could you help me?

23

Bekirdov, How are you calling the stored procedure, within UiPath?
Oracle, SQL Server, MySql?

24

Hello SQL server.

I found the solution. It is not because of the Uipath. problem is caused by SQL Server. there is a deadlock occured while 2 non-query executed at the same Table.

I created a flag table in SQL. While non-quey is working flag becomes 1. And Process is checking the flag. after flag turns to ‘0’ new non-query starts to work.

Thank you.

25

Awesome… Have a great day

26

I cannot get this ever to work, not even if the stored procedure or piece of PL/SQL doesn’t have any parameters.