Execute Query: Value cannot be null. Parameter name: At least one of the connections must be used. i used this connection string "Data Source=(DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=))(ADDRESS=(PROTOCOL=TCP)(HOST=132.0.)(PORT=1521)));Uid=;Pwd=;”

I’m Connected using creadential :" host Name , UserID, password , Service Name ,Port " and Provider Name “oracle.managed asccess”

I'm trying to connect with oracl data base and execute querry from uipath but i got this error

AKM_Robinuzzaman (Robin Zaman) March 31, 2022, 6:02am 14

Hello @yash_p, Please go though the below post:

However, I think that the problem is with the query not with the connection.

Regards,
Robin

Topic		Replies	Views
Execute Query: ERROR [HY000] [Oracle][ODBC][Ora]ORA-00922: missing or invalid option Help database , activities , question	3	1879	December 11, 2020
Error in Query Execution using Mysql Database Studio	2	2876	December 8, 2021
Error when making query using odbc - Oracle Help uiautomation	1	1666	September 17, 2018
While executing the DB query getting error Studio studio , question , workflow_diff	18	2581	March 7, 2023
I'm Getting "System.DBnull" error while excuting Select query after connecting Oracle DB fromo uipath Activities database , bug , completed	9	1755	April 16, 2022