How to run ORACLE stored procedures frim UiPath

Help Orchestrator
,
1

Hello All,

I have one ORACLE stored procedures, which is taking one parameter and will update the record, like below.

abx.Change_status(‘Close’)

I have connected ORACLE server successfully using DSN.

Can anyone help me. Thanks in advance.

2

Hi @sandip.itc

You should be able to provide your input parameter by using the Parameters property:

A parameters configuration window is displayed, showing a single argument named "Argument1", its direction as "In", type as "String", and a blank value field for entering a VB expression. (Captioned by AI)
A parameters configuration window is displayed, showing a single argument named "Argument1", its direction as "In", type as "String", and a blank value field for entering a VB expression. (Captioned by AI)999×244 21.7 KB

1 Like
3

Hello Maciej,

Thanks for the update.

But parameter is the second part. I am not able to call the ORACLE stored procedure from UiPath. I have configured tnsnames.ora file and ODBC Data Source. Connection is successful from ODBC Data Source.

UiPath
UiPath418×333 13.9 KB

When I am running, I am getting this error.
“Run command: ERROR [42000] [Oracle][ODBC]Syntax error or access violation.”

I used both Run command and Run query.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.