I’m trying to return values from an Oracle database using a SELECT query.
I open a connection, like so:
- Activity: UiPath.Database.Activities.DatabaseConnect
- Connection String: “Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=.))(ADDRESS=(PROTOCOL=TCP)(HOST=)(PORT=25888)));Uid=;Pwd=;”
- ProviderName: “System.Data.OracleClient”
I then use that connection (conn) to execute a query. I have tried to pass the query in as a string variable. I then entered it directly into Query text with a parameter (referenced both by “@” and “:”); both variants failed with the ORA-01036 message. I then removed the parameter, and hardcoded the value; it executed.
While it’s nice to see it execute, this scenario doesn’t give me a lot of flexibility.
Has anyone been able to get a QueryStringVariable (sqlTextString) or a parameterized QueryString (with either a @ or “:” to denote the parameter) to return a data set?