Oracle SQL Connection

hi, does anyone know how to connect Oracle SQL developer in UIPATH and get it to read insert statements from excel?

Hi @Kate_Tan

Please find the attached workflow to connect Oracle DB and Querying from Excel.

For this Please install oracle Express edition and Create a Connection string and test it manually in oracle db after that you can use that connection string in UIPATH.

Oracle_DB Conection & Querying.zip (28.8 KB)
Thanks
Latika

1 Like

hi, may i know what are each variables inside the multiple assigns for?

@Kate_Tan

That variables i am reading the provider name connection string and query from input excel.

if i already have the insert statement in the excel cell, how do i read that and input into sql?