Calling an Oracle function from UiPath Studio

I’m trying to call an Oracle function from UiPath Studio.

When I call this function from sqldeveloper there is no issue.

I’m using a Run Query activity, and I added the function call into my query and I’m passing values from the query into the function call.

Like I said in SqlDeveloper there is no issue.

Is there some permissions that I need to grant to be able to execute this function call?

Thanks,
Samuel

This is the error I get

image

Hi @samuel_trahan
First thing you need to check ODBC Connection By putting connection string in TNS.ora file.
Second thing, please check your query syntax

@raja.arslankhan Thanks for the reply.

The connection is fine and works properly.

This is the query that I have

The syntax works and has only given me an issue since I added the function call into the query.