How to handle in UiPath Studio if there is any issue in Stored Procedure?

Help Studio
, , , ,
1

Hi All,

I would like to know how to handle errors that occur in Stored Procedures which is connected to UiPath Studio using Database activities.

Any Help would be appreciated :slight_smile:
Thanks in Advance.

2

Hi @Vaishnav_Tej ,

What error are you getting

Regards,
Arivu

3

Hi,

No error as of now. I’m still in learning stage. So, just wanted to know if any issue is there in Stored Procedure , how to handle from Studio.

4

Hi @Vaishnav_Tej,

you can follow these steps:

  1. Use the Execute Non Query activity to execute the Stored Procedure in the database.
  2. Use a Try Catch activity to handle the error that may occur in the Stored Procedure.
  3. In the Try block, use the Execute Non Query activity to execute the Stored Procedure.
  4. In the Catch block, use the Log Message activity to log the error message.

The “Execute Non Query” activity is part of the “UiPath.Database.Activities” package.